DBA Data[Home] [Help] [Dependency Information]

TABLE: PON.PON_AUC_HEADERS_INTERFACE

Object Details
Object Name: PON_AUC_HEADERS_INTERFACE
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.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.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_AUC_HEADERS_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_AUCTION_HEADER_ID
Columns
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
FREIGHT_TERMS_CODE VARCHAR2 (25)
Freight Terms Code
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.
Query Text

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
,      FREIGHT_TERMS_CODE
,      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
FROM PON.PON_AUC_HEADERS_INTERFACE;

Dependencies

[top of page]

PON.PON_AUC_HEADERS_INTERFACE does not reference any database object

PON.PON_AUC_HEADERS_INTERFACE is referenced by following:

SchemaAPPS
SynonymPON_AUC_HEADERS_INTERFACE