[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ICX_CAT_UPLOAD_PRICE_DUMP |
|---|---|
| Object Type: | TABLE |
| Owner: | ICX |
| FND Design Data: |  ICX.ICX_CAT_UPLOAD_PRICE_DUMP
|
| Subobject Name: | |
| Status: | VALID |
This table is obsolete since R12.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LINE_NUMBER | NUMBER | Yes | Line Number. Denotes line number of price in the file. | |
| ROW_TYPE | VARCHAR2 | (20) | Yes | Indicates type of line being loaded. It will be PRICE. |
| PROCESSED_FLAG | VARCHAR2 | (1) | Yes | Processed flag |
| LANGUAGE | VARCHAR2 | (4) | Yes | Language of the line |
| ACTION | VARCHAR2 | (20) | Action requested by the user on the line. | |
| SYSTEM_ACTION | VARCHAR2 | (20) | Defined system action. | |
| ERROR_FLAG | VARCHAR2 | (1) | Indicates whether an error has been found during validation. | |
| ERROR_MESSAGE | VARCHAR2 | (2000) | Stores error messages if any. | |
| SUPPLIER_ID | NUMBER | Supplier Id of the item | ||
| SUPPLIER | VARCHAR2 | (700) | Supplier Name of the item | |
| SUPPLIER_PART_NUM | VARCHAR2 | (700) | Supplier Part Number of the item | |
| SUPPLIER_PART_AUXID | VARCHAR2 | (255) | Supplier Part Auxiliary ID of the item. Used for CIF/cXML file uploads. Stores '##NULL##' in case this field is not provided in the loader file. | |
| UNIT_PRICE | VARCHAR2 | (700) | Unit price of the Item. | |
| CURRENCY | VARCHAR2 | (15) | Transactional Currency | |
| UNIT_OF_MEASURE | VARCHAR2 | (3) | Unit of measure for the Item. (References MTL_UNITS_OF_MEASURE.unit_of_measure.) | |
| PRICE_LIST_NAME | VARCHAR2 | (255) | Price List Name. Name is 'All-Buyers List Prices' for All Operating Units price list. For Buyer specific price list, list name is stored as '< | |
| PRICE_LIST_ID | NUMBER | The Price List Header Id for the price row. (References ICX_CAT_ITEM_PRICLISTS. PRICE LIST ID) Populated if this price is bulk loaded. | ||
| BUYER_NAME | VARCHAR2 | (255) | Operating Unit Name. | |
| ORG_ID | NUMBER | Operating Unit Id, to which the item belongs. A value of '-2' indicates that the item will be available for All Operating Units.. | ||
| SUPPLIER_SITE_ID | NUMBER | Vendor site id (References po_vendor_sites_all.vendor_site_id). Defaulted with the value -2. | ||
| SUPPLIER_SITE_CODE | VARCHAR2 | (100) | Vendor Site Code (References PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE) | |
| CONTRACT_NUM | VARCHAR2 | (700) | Contract number referenced by the price row. (References the PO_HEADERS_ALL .SEGMENT1) | |
| CONTRACT_ID | NUMBER | Contract ID referenced by the price row. (References the PO_HEADERS_ALL .PO_HEADER_ID) | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column: identifies sign-on audit information of the user who last updated this record. (References FND_LOGINS.login_id.) | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column: the user who last updated this record. (References FND_USERS.user_id.) | ||
| LAST_UPDATE_DATE | DATE | Standard Who column: date when this record was last updated | ||
| CREATED_BY | NUMBER | Standard Who column: the user who created this record. (References FND_USERS.user_id.) | ||
| CREATION_DATE | DATE | Standard Who column: date when this record was created |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_NUMBER
, ROW_TYPE
, PROCESSED_FLAG
, LANGUAGE
, ACTION
, SYSTEM_ACTION
, ERROR_FLAG
, ERROR_MESSAGE
, SUPPLIER_ID
, SUPPLIER
, SUPPLIER_PART_NUM
, SUPPLIER_PART_AUXID
, UNIT_PRICE
, CURRENCY
, UNIT_OF_MEASURE
, PRICE_LIST_NAME
, PRICE_LIST_ID
, BUYER_NAME
, ORG_ID
, SUPPLIER_SITE_ID
, SUPPLIER_SITE_CODE
, CONTRACT_NUM
, CONTRACT_ID
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM ICX.ICX_CAT_UPLOAD_PRICE_DUMP;
ICX.ICX_CAT_UPLOAD_PRICE_DUMP does not reference any database object
ICX.ICX_CAT_UPLOAD_PRICE_DUMP is referenced by following:
APPS
ICX_CAT_UPLOAD_PRICE_DUMP
|
|
|
|