Web Applications Dictionary Configuration for Web Requisitions (Oracle Web Employees Help)


	Previous	Next		Contents	Index		Library

Web Applications Dictionary Configuration for Web Requisitions

This section describes the seeded Web Applications Dictionary settings for Web Requisitions. It also describes conditionally required settings based on your customizations (see the Key Notes section for each region).

Requisition Header

The requisition header contains information on requisition number, note to approver, and so on.

Seeded Settings

Region ID	ICX_SHOPPING_CART_HEADER_R
Object Name	ICX_SHOPPING_CART_HEADER_O
Database Object	ICX_SHOPPING_CART_HEADER_V

Table Legend

Attribute Code The attribute code, which should not be confused with the long label.

Column Name The object column associated with the region attribute.

Node Display Flag Indicates whether the attribute is displayed on screen.

Update Flag Indicates whether the attribute can be updated on screen.

Item Style Method to display attributes, such as Text or Hidden.

Oracle Default Indicates whether an Oracle default value is associated with the attribute.

Oracle Validate Indicates whether the attribute is validated.

Default LOV Region Names Indicates the List of Values region associated with the attribute.

Use to help you control the way attributes display on screen.

Attribute Code Column Name Node Display Flag Update Flag Item Style Oracle Default Oracle Validate Default LOV Region Names

ICX_APPROVER_ID APPROVER_ID N N TEXT Y Y Requestors

ICX_APPROVER_NAME APPROVER_NAME N N TEXT Y Y Requestors

ICX_CART_ID CART_ID Y N HIDDEN Y N

ICX_CHARGE_ACCT_SEG1 -
ICX_CHARGE_ACCT_SEG30 CHARGE_ACCOUNT_
SEGMENT1 -
CHARGE_ACCOUNT_
SEGMENT30 N N TEXT N N

ICX_DELIVER_TO_LOCATION DELIVER_TO_LOCATION Y Y TEXT Y Y Locations

ICX_DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID Y Y HIDDEN Y Y Locations

ICX_DELIVER_TO_REQUESTOR DELIVER_TO_
REQUESTOR Y Y TEXT Y Y Requestors

ICX_DELIVER_TO_REQUESTOR_
ID DELIVER_TO_
REQUESTOR_ID Y Y HIDDEN Y Y Requestors

ICX_DEST_ORG_ID DESTINATION_
ORGANIZATION_ID Y Y HIDDEN Y Y Locations

ICX_HEADER_ATTRIBUTE1 -
ICX_HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE1 -
HEADER_ATTRIBUTE15 N N TEXT N N

ICX_HEADER_ATTRIBUTE_
CATEGORY HEADER_ATTRIBUTE_
CATEGORY N N TEXT N N

ICX_HEADER_DESCRIPTION HEADER_DESCRIPTION Y Y TEXT N N

ICX_NEED_BY_DATE NEED_BY_DATE Y Y TEXT Y Y

ICX_NOTE_TO_APPROVER NOTE_TO_APPROVER Y Y TEXT N N

ICX_NOTE_TO_BUYER NOTE_TO_BUYER Y Y TEXT N N

ICX_PAPER_CLIP Y N TEXT

ICX_REQ_LOC_CD -- Y Y HIDDEN N N Requestors

ICX_REQ_LOC_ID -- Y Y HIDDEN N N Requestors

ICX_REQ_NUMBER_SEQ1 REQ_NUMBER_
SEGMENT1 Y N TEXT Y N

ICX_REQ_ORG_ID -- Y Y HIDDEN N N Requestors

ICX_SAVED_FLAG SAVED_FLAG N N HIDDEN Y N

ICX_SHOPPER_ID SHOPPER_ID N N HIDDEN Y N

Table 1 - 1. (Page 2 of 2)

Attribute Code	Column Name	Node Display Flag	Update Flag	Item Style	Oracle Default	Oracle Validate	Default LOV Region Names
ICX_APPROVER_ID	APPROVER_ID	N	N	TEXT	Y	Y	Requestors
ICX_APPROVER_NAME	APPROVER_NAME	N	N	TEXT	Y	Y	Requestors
ICX_CART_ID	CART_ID	Y	N	HIDDEN	Y	N
ICX_CHARGE_ACCT_SEG1 - ICX_CHARGE_ACCT_SEG30	CHARGE_ACCOUNT_ SEGMENT1 - CHARGE_ACCOUNT_ SEGMENT30	N	N	TEXT	N	N
ICX_DELIVER_TO_LOCATION	DELIVER_TO_LOCATION	Y	Y	TEXT	Y	Y	Locations
ICX_DELIVER_TO_LOCATION_ID	DELIVER_TO_LOCATION_ID	Y	Y	HIDDEN	Y	Y	Locations
ICX_DELIVER_TO_REQUESTOR	DELIVER_TO_ REQUESTOR	Y	Y	TEXT	Y	Y	Requestors
ICX_DELIVER_TO_REQUESTOR_ ID	DELIVER_TO_ REQUESTOR_ID	Y	Y	HIDDEN	Y	Y	Requestors
ICX_DEST_ORG_ID	DESTINATION_ ORGANIZATION_ID	Y	Y	HIDDEN	Y	Y	Locations
ICX_HEADER_ATTRIBUTE1 - ICX_HEADER_ATTRIBUTE15	HEADER_ATTRIBUTE1 - HEADER_ATTRIBUTE15	N	N	TEXT	N	N
ICX_HEADER_ATTRIBUTE_ CATEGORY	HEADER_ATTRIBUTE_ CATEGORY	N	N	TEXT	N	N
ICX_HEADER_DESCRIPTION	HEADER_DESCRIPTION	Y	Y	TEXT	N	N
ICX_NEED_BY_DATE	NEED_BY_DATE	Y	Y	TEXT	Y	Y
ICX_NOTE_TO_APPROVER	NOTE_TO_APPROVER	Y	Y	TEXT	N	N
ICX_NOTE_TO_BUYER	NOTE_TO_BUYER	Y	Y	TEXT	N	N
ICX_PAPER_CLIP		Y	N	TEXT
ICX_REQ_LOC_CD	--	Y	Y	HIDDEN	N	N	Requestors
ICX_REQ_LOC_ID	--	Y	Y	HIDDEN	N	N	Requestors
ICX_REQ_NUMBER_SEQ1	REQ_NUMBER_ SEGMENT1	Y	N	TEXT	Y	N
ICX_REQ_ORG_ID	--	Y	Y	HIDDEN	N	N	Requestors
ICX_SAVED_FLAG	SAVED_FLAG	N	N	HIDDEN	Y	N
ICX_SHOPPER_ID	SHOPPER_ID	N	N	HIDDEN	Y	N
Table 1 - 1. (Page 2 of 2)

Key Notes

Items are attributes only for those attribute codes without column names associated with them. These are reserved for application use.

Attributes set as HIDDEN or BUTTON should not be altered.

Whenever ICX_APPROVER_NAME is set for display and update, ICX_APPROVER_ID must also be set for display and update. The display sequence for these attributes must be set as follows for the list of values to function correctly:

1. ICX_APPROVER_ID

2. ICX_APPROVER_NAME

ICX_CART_ID, ICX_SHOPPER_ID, ICX_PO_BUTTON, ICX_REQ_NUMBER_SEG1, and ICX_SAVED_FLAG are reserved for system use only, and must not be updated.

Whenever ICX_DELIVER_TO_LOCATION is set for display and update, ICX_DEST_ORG_ID and ICX_DELIVER_TO_LOCATION_ID must be set for display and update. The display sequence for these attributes must be set as follows for the list of values to function correctly:

1. ICX_DEST_ORG_ID

2. ICX_DELIVER_TO_LOCATION_ID

3. ICX_DELIVER_TO_LOCATION

Whenever ICX_ DELIVER_TO_REQUESTOR is set for display and update, ICX_DELIVER_TO_REQUESTOR_ID, ICX_REQ_ORG_ID, ICX_REQ_LOC_ID, and ICX_REQ_LOC_CD must be set for display and update, and should remain hidden. The display sequence for these attributes must be set in the following order for list of values to function correctly:

1. ICX_DELIVER_TO_REQUESTOR_ID

2. ICX_DELIVER_TO_REQUESTOR

3. ICX_REQ_ORG_ID

4. ICX_REQ_LOC_ID

5. ICX_REQ_LOC_CD

For a dynamic single field list of values configuration, you must set the following entries for the associated attribute on the form corresponding to thesefs regions:

1. Enable Update and Display in Node flags, and set the Item Style to Text.

2. Set the list of values for Foreign Key.

3. Set the list of values for Region.

4. Set the list of values for Attribute code.

5. Set the Defaulting Region API Proc to Post List of Values.

Web Requisitions does not currently support user configurable lists of values that populate multiple fields. The default list of valuess provided by Web Requisitions may not be overridden or reconfigured as a user defined list of values.

Requisition Lines

Use this region to view or customize how requisition lines are displayed.

Seeded Settings

Region ID	ICX_SHOPPING_CART_LINES_R
Object Name	ICX_SHOPPING_CART_LINES
Database Object	ICX_SHOPPING_CART_LINES_V

Use to help you control the way attributes display on screen. See the Table Legend for detailed information on how to read the following table.

Attribute Code Column Name Node Display Flag Update Flag Item Style Oracle Default Oracle Validate Default LOV Region Names

ICX_ACCT_DIST N N IMAGE

ICX_CART_ID CART_ID N N HIDDEN Y N

ICX_CART_LINE_ID CART_LINE_ID Y N HIDDEN Y N

ICX_CART_LINE_NUM CART_LINE_NUMBER Y N TEXT Y N

ICX_CATEGORY_ID CATEGORY_ID N N HIDDEN Y N

ICX_CATEGORY_NAME CATEGORY_NAME N N HIDDEN Y N

ICX_CHARGE_ACCT_SEG1 -
ICX_CHARGE_ACCT_SEG30 CHARGE_ACCOUNT_
SEGMENT1 -
CHARGE_ACCOUNT_
SEGMENT30 N N TEXT N N

ICX_DELETE -- Y N IMAGE N N

ICX_DELIVER_TO_LOCATION_
ID_L DELIVER_TO_LOCATION_ID N N HIDDEN Y Y Locations

ICX_DELIVER_TO_LOCATION_L DELIVER_TO_LOCATION N N POPLIST Y Y Locations

ICX_DEST_ORG_ID_L DESTINATION_
ORGANIZATION_ID N N HIDDEN Y Y Locations

ICX_EXT_PRICE EXT_PRICE Y N TEXT Y N

ICX_HEADER_ATTRIBUTE_
CATEGORY HEADER_ATTRIBUTE_
CATEGORY N N TEXT N N

ICX_ITEM_DESCRIPTION ITEM_DESCRIPTION Y N TEXT Y N

ICX_ITEM_ID ITEM_ID N N HIDDEN Y N

ICX_ITEM_NUMBER ITEM_NUMBER Y N TEXT Y N

ICX_ITEM_REV ITEM_REVISION N N HIDDEN Y N

ICX_LINE_ATTRIBUTE1 -
ICX_LINE_ATTRIBUTE15 HEADER_ATTRIBUTE1 -
HEADER_ATTRIBUTE15 N N TEXT N N

ICX_LINE_ID LINE_ID N N HIDDEN Y N

ICX_LINE_TYPE_ID LINE_TYPE_ID N N HIDDEN Y N

ICX_NEED_BY_DATE NEED_BY_DATE N N TEXT Y Y

ICX_PAPER_CLIP Y N IMAGE

ICX_QTY_V QUANTITY Y Y TEXT N Y

ICX_SHOPPER_ID SHOPPER_ID N N HIDDEN Y N

ICX_SPLIT -- Y N IMAGE N N

ICX_SUGGESTED_VENDOR_
NAME SUGGESTED_VENDOR_NAME Y N TEXT Y y

ICX_SUGGESTED_VENDOR_
SITE SUGGESTED_VENDOR_SITE N N TEXT Y N

ICX_SUGGESTED_VENDOR_
CONTACT SUGGESTED_VENDOR_CONTACT N N TEXT Y N

ICX_SUGGESTED_VENDOR_
PHONE SUGGESTED_VENDOR_
PHONE N N TEXT N N

ICX_SUGGESTED_VENDOR_
ITEM_NUM SUGGESTED_VENDOR_ITEM_NUM Y N TEXT Y N

ICX_UNIT_OF_MEASUREMENT UNIT_OF_MEASURE Y N TEXT Y N

ICX_UNIT_PRICE UNIT_PRICE Y N TEXT Y N

Table 1 - 2.

Attribute Code	Column Name	Node Display Flag	Update Flag	Item Style	Oracle Default	Oracle Validate	Default LOV Region Names
ICX_ACCT_DIST		N	N	IMAGE
ICX_CART_ID	CART_ID	N	N	HIDDEN	Y	N
ICX_CART_LINE_ID	CART_LINE_ID	Y	N	HIDDEN	Y	N
ICX_CART_LINE_NUM	CART_LINE_NUMBER	Y	N	TEXT	Y	N
ICX_CATEGORY_ID	CATEGORY_ID	N	N	HIDDEN	Y	N
ICX_CATEGORY_NAME	CATEGORY_NAME	N	N	HIDDEN	Y	N
ICX_CHARGE_ACCT_SEG1 - ICX_CHARGE_ACCT_SEG30	CHARGE_ACCOUNT_ SEGMENT1 - CHARGE_ACCOUNT_ SEGMENT30	N	N	TEXT	N	N
ICX_DELETE	--	Y	N	IMAGE	N	N
ICX_DELIVER_TO_LOCATION_ ID_L	DELIVER_TO_LOCATION_ID	N	N	HIDDEN	Y	Y	Locations
ICX_DELIVER_TO_LOCATION_L	DELIVER_TO_LOCATION	N	N	POPLIST	Y	Y	Locations
ICX_DEST_ORG_ID_L	DESTINATION_ ORGANIZATION_ID	N	N	HIDDEN	Y	Y	Locations
ICX_EXT_PRICE	EXT_PRICE	Y	N	TEXT	Y	N
ICX_HEADER_ATTRIBUTE_ CATEGORY	HEADER_ATTRIBUTE_ CATEGORY	N	N	TEXT	N	N
ICX_ITEM_DESCRIPTION	ITEM_DESCRIPTION	Y	N	TEXT	Y	N
ICX_ITEM_ID	ITEM_ID	N	N	HIDDEN	Y	N
ICX_ITEM_NUMBER	ITEM_NUMBER	Y	N	TEXT	Y	N
ICX_ITEM_REV	ITEM_REVISION	N	N	HIDDEN	Y	N
ICX_LINE_ATTRIBUTE1 - ICX_LINE_ATTRIBUTE15	HEADER_ATTRIBUTE1 - HEADER_ATTRIBUTE15	N	N	TEXT	N	N
ICX_LINE_ID	LINE_ID	N	N	HIDDEN	Y	N
ICX_LINE_TYPE_ID	LINE_TYPE_ID	N	N	HIDDEN	Y	N
ICX_NEED_BY_DATE	NEED_BY_DATE	N	N	TEXT	Y	Y
ICX_PAPER_CLIP		Y	N	IMAGE
ICX_QTY_V	QUANTITY	Y	Y	TEXT	N	Y
ICX_SHOPPER_ID	SHOPPER_ID	N	N	HIDDEN	Y	N
ICX_SPLIT	--	Y	N	IMAGE	N	N
ICX_SUGGESTED_VENDOR_ NAME	SUGGESTED_VENDOR_NAME	Y	N	TEXT	Y	y
ICX_SUGGESTED_VENDOR_ SITE	SUGGESTED_VENDOR_SITE	N	N	TEXT	Y	N
ICX_SUGGESTED_VENDOR_ CONTACT	SUGGESTED_VENDOR_CONTACT	N	N	TEXT	Y	N
ICX_SUGGESTED_VENDOR_ PHONE	SUGGESTED_VENDOR_ PHONE	N	N	TEXT	N	N
ICX_SUGGESTED_VENDOR_ ITEM_NUM	SUGGESTED_VENDOR_ITEM_NUM	Y	N	TEXT	Y	N
ICX_UNIT_OF_MEASUREMENT	UNIT_OF_MEASURE	Y	N	TEXT	Y	N
ICX_UNIT_PRICE	UNIT_PRICE	Y	N	TEXT	Y	N
Table 1 - 2.

Key Notes

ICX_CART_LINE_ID must be set for display, hidden, and not for update, and must be set at the first position in the display sequence.

ICX_CART_ID, ICX_SHOPPER_ID, ICX_CART_LINE_NUMBER must be set for not updatable, hidden, and reserved for system use only. ICX_CART_LINE_NUMBER should be set for display as an exception.

ICX_LINE_ID, ICX_ITEM_ID, ICX_CATEGORY_ID, ICX_CATEGORY_NAME and ICX_LINE_TYPE_ID should always be set as hidden and not updatable.

For both regions, whenever ICX_DELIVER_TO_LOCATION_L is set for display and update, ICX_DELIVER_TO_LOCATION_ID_L and ICX_DEST_ORG_ID_L must be set for display and update. ICX_DELIVER_TO_LOCATION_ID_L and ICX_DEST_ORG_ID_L should be set to have an item style of Hidden. ICX_DELIVER_TO_LOCATION_L must be set for an item style as Poplist. All these actions enable list of values functionality. The display sequence must also be set as follows:

1. ICX_DEST_ORG_ID_L

2. ICX_DELIVER_TO_LOCATION_ID_L

3. ICX_DELIVER_TO_LOCATION_L

The following rules on Location Code defaults apply to the current submit of the My Order page, corresponding to the various Web Applications Dictionary settings in the ICX_SHOPPING_CART_LINES_R. and ICX_SHOPPING_CART_LINES_EMG_R regions:

Header	Line	Rules
Off	Off	1. default into header from requestor when click on 'New Req'
		2. copy into lines from header when 'Add to Order'
		3. copy into lines from header when Submit/Apply Changes
On	Off	1. default into header from requestor when click on 'New Req'
		2. copy into lines from header when 'Add to Order'
		3. copy into lines from header when Submit/Apply Changes
On	On	1. default into header from requestor when click on 'New Req'
		2. copy into lines from header when 'Add to Order'
		3. update from line on form when Submit/Apply Changes
Off	On	1. default into header from requestor when click on 'New Req'
		2. copy into lines from header when 'Add to Order'
		3. update from line on form when Submit/Apply Changes
Table 1 - 3.

Whenever one of the following is set for display and update, then all must be set for display and update: ICX_SUGGESTED_VENDOR_NAME, ICX_SUGGESTED_VENDOR_SITE, ICX_SUGGESTED_VENDOR_PHONE, ICX_SUGGESTED_VENDOR_CONTACT. If this is the case, the sequence must be defined as follows without any other attributes between these four fields for list of values functionality:

1. ICX_SUGGESTED_VENDOR_NAME (Item Style must be set to Poplist)

2. ICX_SUGGESTED_VENDOR_SITE

3. ICX_SUGGESTED_VENDOR_CONTACT

4. ICX_SUGGESTED_VENDOR_PHONE

Once submitted, saved, or changes applied, any cart line that does not have a Supplier entry will be defaulted to the supplier entered at the first cart line. Validation ensures there is at least one supplier entered.

ICX_SPLIT and ICX_DELETE item style must be Image to enable copy and delete line functions.

For a dynamic single-field list of values configuration, you must set the following entries for the associated attribute corresponding to this region:

1. Enable the Update and Display in Node flags, and set the Item Style to Text.

2. Set the list of values for Foreign Key.

3. Set the list of values for Region.

4. Set the list of values for Attribute Code.

5. Set the Defaulting Region API Proc to Post List of Values.

Special Orders

Use this region to view or customize the display of the Special Order page, where you can order items on a one-time basis.

Seeded Settings

Region ID	ICX_REQ_SPECIAL_ORDER
Object Name	ICX_REQ_SPECIAL_ORDER
Database Object	ICX_REQ_ONE_TIME_V

Use to help you control the way attributes display on screen. See the Table Legend for detailed information on how to read the following table.

Attribute Code Node Display Flag Update Flag Item Style Oracle Default Oracle Validate Default LOV Region Names

ICX_CATEGORY_ID N N HIDDEN Y N

ICX_CATEGORY_NAME Y Y POPLIST Y N

ICX_ITEM_DESCRIPTION Y Y TEXT N N

ICX_UNIT_OF_MEASUREMENT Y Y POPLIST Y N

ICX_QTY Y Y TEXT N N

ICX_UNIT_PRICE Y Y TEXT N N

ICX_SUGGESTED_VENDOR_ITEM_NUM Y Y TEXT N N Supplier LOV

ICX_SUGGESTED_VENDOR_NAME Y Y TEXT N N Supplier LOV

ICX_SUGGESTED_VENDOR_SITE Y Y TEXT N N Supplier LOV

ICX_SUGGESTED_VENDOR_CONTACT Y Y TEXT N N Supplier LOV

ICX_SUGGESTED_VENDOR_PHONE Y Y TEXT N N Supplier LOV

ICX_LINE_ATTRIBUTE_1
ICX_LINE_ATTRIBUTE_15 N N HIDDEN N N

ICX_LINE_TYPE_ID Y Y HIDDEN N N

Table 1 - 4. (Page 1 of 1)

Attribute Code	Node Display Flag	Update Flag	Item Style	Oracle Default	Oracle Validate	Default LOV Region Names
ICX_CATEGORY_ID	N	N	HIDDEN	Y	N
ICX_CATEGORY_NAME	Y	Y	POPLIST	Y	N
ICX_ITEM_DESCRIPTION	Y	Y	TEXT	N	N
ICX_UNIT_OF_MEASUREMENT	Y	Y	POPLIST	Y	N
ICX_QTY	Y	Y	TEXT	N	N
ICX_UNIT_PRICE	Y	Y	TEXT	N	N
ICX_SUGGESTED_VENDOR_ITEM_NUM	Y	Y	TEXT	N	N	Supplier LOV
ICX_SUGGESTED_VENDOR_NAME	Y	Y	TEXT	N	N	Supplier LOV
ICX_SUGGESTED_VENDOR_SITE	Y	Y	TEXT	N	N	Supplier LOV
ICX_SUGGESTED_VENDOR_CONTACT	Y	Y	TEXT	N	N	Supplier LOV
ICX_SUGGESTED_VENDOR_PHONE	Y	Y	TEXT	N	N	Supplier LOV
ICX_LINE_ATTRIBUTE_1 ICX_LINE_ATTRIBUTE_15	N	N	HIDDEN	N	N
ICX_LINE_TYPE_ID	Y	Y	HIDDEN	N	N
Table 1 - 4. (Page 1 of 1)

Key Notes

ICX_ITEM_DESCRIPTION, ICX_QTY, ICX_UNIT_PRICE, ICX_UNIT_OF_MEASUREMENT and ICX_CATEGORY_NAME are required fields and must to be set for display and update.

If you have many item categories and prefer a list of values to a poplist, set the ICX_CATEGORY_NAME item style to Text. Otherwise, the default is Poplist. The same is true for ICX_UNIT_OF_MEASUREMENT.

If ICX_CATEGORY_NAME is set for list of values, then ICX_CATEGORY_ID must be set for display, hidden, and updatable.

Whenever one of the following is set for display and update, then all must be set for display and update: ICX_SUGGESTED_VENDOR_NAME, ICX_SUGGESTED_VENDOR_CONTACT, ICX_SUGGESTED_VENDOR_PHONE and ICX_SUGGESTED_VENDOR_SITE .

Templates

Use this region to view or customize the Templates defined in the requisition.

Seeded Settings

Region ID	ICX_PO_TEMPLATE_ITEMS_R
Object Name	ICX_PO_REQ_TEMPLATE_ITEMS_O
Database Object	ICX_PO_REQ_TEMPLATE_ITEMS_V

Use to help you control the way attributes display on screen. See the Table Legend for detailed information on how to read the following table.

Attribute Code Column Name Node Display Flag Update Flag Item Style Oracle Default Oracle Validate

ICX_ITEM_NUMBER ITEM_NUMBER Y N TEXT Y N

ICX_ITEM_DESCRIPTION ITEM_DESCRIPTION Y N TEXT Y N

ICX_UNIT_OF_MEASUREMENT UOM Y N TEXT Y N

ICX_QTY - Y Y TEXT N N

ICX_UNIT_PRICE PRICE Y N TEXT Y N

ICX_SUGGESTED_VENDOR_NAME SOURCE_NAME Y N TEXT Y N

ICX_SUGGESTED_VENDOR_ITEM_NUM SUGGESTED_VENDOR_PRODUCT_CODE Y N TEXT Y N

ICX_EXPRESS_NAME EXPRESS_NAME N N TEXT Y N

ICX_DESC DESCRIPTION N N TEXT Y N

ICX_LINE_ID LINE_ID N N TEXT Y N

ICX_DOCUMENT_TYPE DOCUMENT_TYPE N N TEXT Y N

ICX_SEQUENCE SEQUENCE_NUM N N TEXT Y N

ICX_ITEM_ID ITEM_ID N N TEXT Y N

ICX_CATEGORY_ID CATEGORY_ID N N TEXT Y N

ICX_SUPPLIER_URL SUPPLIER_URL N N TEXT Y N

ICX_SUPPLIER_ITEM_URL SUPPLIER_ITEM_URL N N TEXT Y N

ICX_ITEM_URL ITEM_URL N Y TEXT Y N

ICX_ITEM_REV ITEM_REVISION N N TEXT Y N

ICX_LINE_TYPE_ID LINE_TYPE_ID N N TEXT Y N

Table 1 - 5. (Page 2 of 2)

Attribute Code	Column Name	Node Display Flag	Update Flag	Item Style	Oracle Default	Oracle Validate
ICX_ITEM_NUMBER	ITEM_NUMBER	Y	N	TEXT	Y	N
ICX_ITEM_DESCRIPTION	ITEM_DESCRIPTION	Y	N	TEXT	Y	N
ICX_UNIT_OF_MEASUREMENT	UOM	Y	N	TEXT	Y	N
ICX_QTY	-	Y	Y	TEXT	N	N
ICX_UNIT_PRICE	PRICE	Y	N	TEXT	Y	N
ICX_SUGGESTED_VENDOR_NAME	SOURCE_NAME	Y	N	TEXT	Y	N
ICX_SUGGESTED_VENDOR_ITEM_NUM	SUGGESTED_VENDOR_PRODUCT_CODE	Y	N	TEXT	Y	N
ICX_EXPRESS_NAME	EXPRESS_NAME	N	N	TEXT	Y	N
ICX_DESC	DESCRIPTION	N	N	TEXT	Y	N
ICX_LINE_ID	LINE_ID	N	N	TEXT	Y	N
ICX_DOCUMENT_TYPE	DOCUMENT_TYPE	N	N	TEXT	Y	N
ICX_SEQUENCE	SEQUENCE_NUM	N	N	TEXT	Y	N
ICX_ITEM_ID	ITEM_ID	N	N	TEXT	Y	N
ICX_CATEGORY_ID	CATEGORY_ID	N	N	TEXT	Y	N
ICX_SUPPLIER_URL	SUPPLIER_URL	N	N	TEXT	Y	N
ICX_SUPPLIER_ITEM_URL	SUPPLIER_ITEM_URL	N	N	TEXT	Y	N
ICX_ITEM_URL	ITEM_URL	N	Y	TEXT	Y	N
ICX_ITEM_REV	ITEM_REVISION	N	N	TEXT	Y	N
ICX_LINE_TYPE_ID	LINE_TYPE_ID	N	N	TEXT	Y	N
Table 1 - 5. (Page 2 of 2)

Key Notes

ICX_QTY_V is always set for display regardless of Web Applications Dictionary customer settings.

ICX_SEQUENCE is always set for display and hidden.

Catalog

Use this region to view or customize the display of the Catalog page.

Seeded Settings

Region ID	ICX_PO_SUPPL_CATALOG_ITEMS_R
Object Name	ICX_PO_SUPPL_CATALOG_ITEMS_O
Database Object	ICX_PO_SUPPL_CATALOG_ITEMS_V

Attribute Code Column Name Node Display Flag Update Flag Item Style Oracle Default Oracle Validate

ICX_ITEM_NUMBER ITEM_NUMBER Y N TEXT Y N

ICX_ITEM_DESCRIPTION ITEM_DESCRIPTION Y N TEXT Y N

ICX_UNIT_OF_MEASUREMENT LINE_UOM Y N TEXT Y N

ICX_QTY QUANTITY Y Y TEXT Y Y

ICX_UNIT_PRICE PRICE Y N TEXT Y N

ICX_SUGGESTED_VENDOR_NAME VENDOR_NAME Y N TEXT Y N

ICX_SUGGESTED_VENDOR_
ITEM_NUM VENDOR_PRODUCT_NUM Y N TEXT Y N

ICX_LINE_ID PO_LINE_ID N N TEXT Y N

ICX_ITEM_ID ITEM_ID N N TEXT Y N

ICX_SUGGESTED_VENDOR_SITE VENDOR_SITE_ID N N TEXT Y N

ICX_LINE_TYPE_ID LINE_TYPE_ID N N TEXT Y N

ICX_CATEGORY_ID CATEGORY_ID N N TEXT Y N

ICX_CATEGORY_NAME CATEGORY_NAME N N TEXT Y N

ICX_SUPPLIER_URL SUPPLIER_URL N N TEXT Y N

ICX_ITEM_URL ITEM_URL N N TEXT Y N

ICX_SUPPLIER_ITEM_URL SUPPLIER_ITEM_URL N N TEXT Y N

Table 1 - 6. (Page 1 of 1)

Attribute Code	Column Name	Node Display Flag	Update Flag	Item Style	Oracle Default	Oracle Validate
ICX_ITEM_NUMBER	ITEM_NUMBER	Y	N	TEXT	Y	N
ICX_ITEM_DESCRIPTION	ITEM_DESCRIPTION	Y	N	TEXT	Y	N
ICX_UNIT_OF_MEASUREMENT	LINE_UOM	Y	N	TEXT	Y	N
ICX_QTY	QUANTITY	Y	Y	TEXT	Y	Y
ICX_UNIT_PRICE	PRICE	Y	N	TEXT	Y	N
ICX_SUGGESTED_VENDOR_NAME	VENDOR_NAME	Y	N	TEXT	Y	N
ICX_SUGGESTED_VENDOR_ ITEM_NUM	VENDOR_PRODUCT_NUM	Y	N	TEXT	Y	N
ICX_LINE_ID	PO_LINE_ID	N	N	TEXT	Y	N
ICX_ITEM_ID	ITEM_ID	N	N	TEXT	Y	N
ICX_SUGGESTED_VENDOR_SITE	VENDOR_SITE_ID	N	N	TEXT	Y	N
ICX_LINE_TYPE_ID	LINE_TYPE_ID	N	N	TEXT	Y	N
ICX_CATEGORY_ID	CATEGORY_ID	N	N	TEXT	Y	N
ICX_CATEGORY_NAME	CATEGORY_NAME	N	N	TEXT	Y	N
ICX_SUPPLIER_URL	SUPPLIER_URL	N	N	TEXT	Y	N
ICX_ITEM_URL	ITEM_URL	N	N	TEXT	Y	N
ICX_SUPPLIER_ITEM_URL	SUPPLIER_ITEM_URL	N	N	TEXT	Y	N
Table 1 - 6. (Page 1 of 1)

Key Notes

ICX_QTY_V is always set for display regardless of Web Applications Dictionary customer settings.

Search

Use this region to view or customize the display of the Search page. The view associated with this region uses the Oracle ConText table for the search.

Seeded Settings

Region ID	ICX_PO_SUPPL_SEARCH_ITEMS_R
Object Name	ICX_PO_SUPPL_SEARCH_ITEMS_O
Database Object	ICX_PO_SUPPL_SEARCH_ITEMS_V

Attribute Code Column Name Node Display Flag Update Flag Item Style Oracle Default Oracle Validate

ICX_ITEM_NUMBER ITEM_NUMBER Y N TEXT Y N

ICX_ITEM_DESCRIPTION ITEM_DESCRIPTION Y N TEXT Y N

ICX_UNIT_OF_MEASUREMENT LINE_UOM Y N TEXT Y N

ICX_QTY QUANTITY Y Y TEXT Y Y

ICX_UNIT_PRICE PRICE Y N TEXT Y N

ICX_SUGGESTED_VENDOR_NAME VENDOR_NAME Y N TEXT Y N

ICX_SUGGESTED_VENDOR_
ITEM_NUM VENDOR_PRODUCT_NUM Y N TEXT Y N

ICX_LINE_ID PO_LINE_ID N N TEXT Y N

ICX_ITEM_ID ITEM_ID N N TEXT Y N

ICX_SUGGESTED_VENDOR_SITE VENDOR_SITE_ID N N TEXT Y N

ICX_LINE_TYPE_ID LINE_TYPE_ID N N TEXT Y N

ICX_CATEGORY_ID CATEGORY_ID N N TEXT Y N

ICX_CATEGORY_NAME CATEGORY_NAME N N TEXT Y N

ICX_SUPPLIER_URL SUPPLIER_URL N N TEXT Y N

ICX_ITEM_URL ITEM_URL N N TEXT Y N

ICX_SUPPLIER_ITEM_URL SUPPLIER_ITEM_URL N N TEXT Y N

Table 1 - 7. (Page 1 of 1)

Attribute Code	Column Name	Node Display Flag	Update Flag	Item Style	Oracle Default	Oracle Validate
ICX_ITEM_NUMBER	ITEM_NUMBER	Y	N	TEXT	Y	N
ICX_ITEM_DESCRIPTION	ITEM_DESCRIPTION	Y	N	TEXT	Y	N
ICX_UNIT_OF_MEASUREMENT	LINE_UOM	Y	N	TEXT	Y	N
ICX_QTY	QUANTITY	Y	Y	TEXT	Y	Y
ICX_UNIT_PRICE	PRICE	Y	N	TEXT	Y	N
ICX_SUGGESTED_VENDOR_NAME	VENDOR_NAME	Y	N	TEXT	Y	N
ICX_SUGGESTED_VENDOR_ ITEM_NUM	VENDOR_PRODUCT_NUM	Y	N	TEXT	Y	N
ICX_LINE_ID	PO_LINE_ID	N	N	TEXT	Y	N
ICX_ITEM_ID	ITEM_ID	N	N	TEXT	Y	N
ICX_SUGGESTED_VENDOR_SITE	VENDOR_SITE_ID	N	N	TEXT	Y	N
ICX_LINE_TYPE_ID	LINE_TYPE_ID	N	N	TEXT	Y	N
ICX_CATEGORY_ID	CATEGORY_ID	N	N	TEXT	Y	N
ICX_CATEGORY_NAME	CATEGORY_NAME	N	N	TEXT	Y	N
ICX_SUPPLIER_URL	SUPPLIER_URL	N	N	TEXT	Y	N
ICX_ITEM_URL	ITEM_URL	N	N	TEXT	Y	N
ICX_SUPPLIER_ITEM_URL	SUPPLIER_ITEM_URL	N	N	TEXT	Y	N
Table 1 - 7. (Page 1 of 1)

Key Notes

ICX_QTY_V is always set for display regardless of Web Applications Dictionary customer settings.

Contents

Index

Library

Attribute Code	The attribute code, which should not be confused with the long label.
Column Name	The object column associated with the region attribute.
Node Display Flag	Indicates whether the attribute is displayed on screen.
Update Flag	Indicates whether the attribute can be updated on screen.
Item Style	Method to display attributes, such as Text or Hidden.
Oracle Default	Indicates whether an Oracle default value is associated with the attribute.
Oracle Validate	Indicates whether the attribute is validated.
Default LOV Region Names	Indicates the List of Values region associated with the attribute.