[Home] [Help] [Dependency Information]
Object Name: | PON_AUC_HEADERS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | PON |
FND Design Data: | PON.PON_AUC_HEADERS_INTERFACE |
Subobject Name: | |
Status: | VALID |
PON_AUC_HEADERS_INTERFACE holds Negotiation header 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_HEADERS_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_AUCTION_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_AUCTION_HEADER_ID | NUMBER | Yes | Unique Interface Header Id | |
NEG_TYPE | VARCHAR2 | (25) | Yes | Negotiation Type |
CONTRACT_TYPE | VARCHAR2 | (25) | Contract Type | |
SHIP_TO_LOCATION_ID | NUMBER | Ship-To Location Id | ||
BILL_TO_LOCATION_ID | NUMBER | Bill-To Location Id | ||
PAYMENT_TERMS_ID | NUMBER | Payment Terms Id | ||
FOB_CODE | VARCHAR2 | (25) | FOB Code | |
CARRIER_CODE | VARCHAR2 | (25) | Carrier Code | |
NOTE_TO_BIDDERS | VARCHAR2 | (4000) | Note to Bidders | |
ALLOW_OTHER_BID_CURRENCY_FLAG | VARCHAR2 | (1) | Allow other bid currency flag | |
PO_AGREED_AMOUNT | NUMBER | PO Agreed Amount | ||
GLOBAL_AGREEMENT_FLAG | VARCHAR2 | (1) | Is this a Global Agreement | |
ORIGINATION_CODE | VARCHAR2 | (30) | Origination Code | |
PO_MIN_REL_AMOUNT | NUMBER | PO Minimum Release Amount | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
RATE_TYPE | VARCHAR2 | (25) | Currency Rate Type | |
RATE_DATE | DATE | Currency Rate Date | ||
RATE | NUMBER | Currency Rate | ||
USER_ID | NUMBER | User | ||
ORG_ID | NUMBER | Organization Id | ||
SUPPLIER_ID | NUMBER | Supplier who is on the PO Blanket Agreement | ||
PROCESS_STATUS | VARCHAR2 | (20) | Processing Status | |
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 | ||
SOURCE_DOC_NUMBER | VARCHAR2 | (20) | Source Document Number | |
SOURCE_DOC_ID | NUMBER | Source Document ID | ||
SOURCE_DOC_MSG | VARCHAR2 | (30) | Source Document Display Message Name | |
SOURCE_DOC_LINE_MSG | VARCHAR2 | (30) | Source Document Line Display Message Name | |
SOURCE_DOC_MSG_APP | VARCHAR2 | (3) | Source Document Message Name Application Shortname | |
SUPPLIER_SITE_ID | NUMBER | Supplier Site on the PO Blanket Agreement | ||
PO_STYLE_ID | NUMBER | Part of the unique key of PO style for the negotiation. The other part, PO document type, is stored in contract_type. | ||
LANGUAGE_CODE | VARCHAR2 | (4) | Language code of the source blanket. | |
FREIGHT_TERMS_CODE#1 | VARCHAR2 | (30) | Freight Terms Code |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_AUCTION_HEADER_ID
, NEG_TYPE
, CONTRACT_TYPE
, SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID
, PAYMENT_TERMS_ID
, FOB_CODE
, CARRIER_CODE
, NOTE_TO_BIDDERS
, ALLOW_OTHER_BID_CURRENCY_FLAG
, PO_AGREED_AMOUNT
, GLOBAL_AGREEMENT_FLAG
, ORIGINATION_CODE
, PO_MIN_REL_AMOUNT
, CURRENCY_CODE
, RATE_TYPE
, RATE_DATE
, RATE
, USER_ID
, ORG_ID
, SUPPLIER_ID
, PROCESS_STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SOURCE_DOC_NUMBER
, SOURCE_DOC_ID
, SOURCE_DOC_MSG
, SOURCE_DOC_LINE_MSG
, SOURCE_DOC_MSG_APP
, SUPPLIER_SITE_ID
, PO_STYLE_ID
, LANGUAGE_CODE
, FREIGHT_TERMS_CODE#1
FROM PON.PON_AUC_HEADERS_INTERFACE;
PON.PON_AUC_HEADERS_INTERFACE does not reference any database object
PON.PON_AUC_HEADERS_INTERFACE is referenced by following:
|
|
|