[Home] [Help] [Dependency Information]
Object Name: | PON_AUC_ITEMS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | PON |
FND Design Data: | PON.PON_AUC_ITEMS_INTERFACE |
Subobject Name: | |
Status: | VALID |
PON_AUC_ITEMS_INTERFACE holds Negotiation item information that will be used to create a draft sourcing negotiation.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PON_AUC_ITEMS_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
INTERFACE_AUCTION_HEADER_ID
INTERFACE_LINE_NUMBER |
PON_AUC_ITEMS_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
SOURCE_DOC_ID
SOURCE_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_AUCTION_HEADER_ID | NUMBER | Yes | Unique Interface Header Id | |
INTERFACE_LINE_NUMBER | NUMBER | Yes | Unique Interface Line Number | |
LINE_TYPE_ID | NUMBER | Item line type | ||
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Line type order type | |
ITEM_DESCRIPTION | VARCHAR2 | (2500) | Item description | |
ORG_ID | NUMBER | Organization Id | ||
CATEGORY_ID | NUMBER | Category Id | ||
CATEGORY_NAME | VARCHAR2 | (250) | Category Name | |
QUANTITY | NUMBER | Quantity | ||
BID_START_PRICE | NUMBER | Bid Start Price | ||
NOTE_TO_BIDDERS | VARCHAR2 | (4000) | Note to Bidders | |
UOM_CODE | VARCHAR2 | (3) | UOM Code | |
ORIGINATION_CODE | VARCHAR2 | (30) | Line Orgination Code | |
PO_MIN_REL_AMOUNT | NUMBER | PO Minimum Release Amount | ||
PRICE_BREAK_TYPE | VARCHAR2 | (25) | What type of price break | |
ITEM_ID | NUMBER | Item Id | ||
ITEM_NUMBER | VARCHAR2 | (820) | Item Number | |
ITEM_REVISION | VARCHAR2 | (3) | Item Revision | |
SOURCE_DOC_NUMBER | VARCHAR2 | (20) | Source Document Number for display | |
SOURCE_LINE_NUMBER | VARCHAR2 | (20) | Source Document Line Number for display | |
SOURCE_DOC_ID | NUMBER | Source Document Id | ||
SOURCE_LINE_ID | NUMBER | Source Document Line Id | ||
HAS_SHIPMENTS_FLAG | VARCHAR2 | (1) | If the item has shipments | |
CREATED_BY | NUMBER | Standard Who Column | ||
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
JOB_ID | NUMBER | Job unique identifier | ||
PO_AGREED_AMOUNT | NUMBER | Budgeted purchase order amount | ||
PURCHASE_BASIS | VARCHAR2 | (25) | Purchase basis | |
IP_CATEGORY_ID | NUMBER | iP category id. | ||
CURRENT_PRICE | NUMBER | Stores the current price for the line. |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_AUCTION_HEADER_ID
, INTERFACE_LINE_NUMBER
, LINE_TYPE_ID
, ORDER_TYPE_LOOKUP_CODE
, ITEM_DESCRIPTION
, ORG_ID
, CATEGORY_ID
, CATEGORY_NAME
, QUANTITY
, BID_START_PRICE
, NOTE_TO_BIDDERS
, UOM_CODE
, ORIGINATION_CODE
, PO_MIN_REL_AMOUNT
, PRICE_BREAK_TYPE
, ITEM_ID
, ITEM_NUMBER
, ITEM_REVISION
, SOURCE_DOC_NUMBER
, SOURCE_LINE_NUMBER
, SOURCE_DOC_ID
, SOURCE_LINE_ID
, HAS_SHIPMENTS_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, JOB_ID
, PO_AGREED_AMOUNT
, PURCHASE_BASIS
, IP_CATEGORY_ID
, CURRENT_PRICE
FROM PON.PON_AUC_ITEMS_INTERFACE;
PON.PON_AUC_ITEMS_INTERFACE does not reference any database object
PON.PON_AUC_ITEMS_INTERFACE is referenced by following:
|
|
|