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

TABLE: GML.CPG_PURCHASING_INTERFACE

Object Details
Object Name: CPG_PURCHASING_INTERFACE
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.CPG_PURCHASING_INTERFACE
Subobject Name:
Status: VALID


Interface table used by OPM Common Purchasing. Contains data from Standard and Planned Purchase Orders and Scheduled and Blanket Releases entered and approved in Oracle Purchasing. This data is used by the OPM Common Purchasing Synchronization program to create PO's and BPO's in OPM. The program takes the data in this table and transfers it into corresponding OPM tables: For PO's, the data is transferred into the tables PO_ORDR_HDR, PO_ORDR_DTL, PO_DIST_DTL, PO_COST_DTL and IC_TRAN_PND. For BPO's, the data is transferred into the tables PO_BPOS_HDR, PO_BPOS_DTL and PO_RELS_SCH.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Id to uniquely identify row in interface table
TRANSACTION_TYPE VARCHAR2 (10) Yes Type of PO - STANDARD or PLANNED
ORGN_CODE VARCHAR2 (4)
OPM organization code from flexfield in Oracle Purchasing
PO_NO VARCHAR2 (32) Yes Purchase order number assigned in Oracle Purchasing
BPO_NO VARCHAR2 (32)
Purchase order number for planned purchase order assigned in Oracle Purchasing
PO_STATUS VARCHAR2 (25)
Status of PO - OPEN, CLOSED or CANCEL
PO_HEADER_ID NUMBER

PO Header id from Oracle Purchasing
PO_LINE_ID NUMBER

PO line id from Oracle Purchasing
PO_LINE_LOCATION_ID NUMBER

PO line location id from Oracle Purchasing
PO_DISTRIBUTION_ID NUMBER

PO distribution id from Oracle Purchasing
PO_RELEASE_ID NUMBER

PO release id (if PO is release) from Oracle Purchasing
RELEASE_NUM NUMBER

Release number from Oracle Purchasing
BUYER_CODE VARCHAR2 (35)
Buyer name from Oracle Purchasing
PO_ID NUMBER (10)
Surrogate for PO header created in OPM
BPO_ID NUMBER (10)
Surrogate for Blanket Purchase Order created in OPM (for Planned Purchase Orders)
BPO_RELEASE_NUMBER NUMBER

BPO release number in OPM; may be same as BPO_ID
OF_PAYVEND_SITE_ID NUMBER

Surrogate from Oracle Supplier Site which designates pay vendor
OF_SHIPVEND_SITE_ID NUMBER

Surrogate for Oracle Supplier Site which designates ship-to vendor
PO_DATE DATE

PO Date
PO_TYPE NUMBER

PO type
FROM_WHSE VARCHAR2 (4)
From warehouse - not supported - is always NULL
TO_WHSE VARCHAR2 (4)
To warehouse in OPM - equals ship-to location from Oracle PO
RECV_DESC VARCHAR2 (40)
Receiving description for OPM - is always NULL
RECV_LOCT VARCHAR2 (16)
Receiving location for OPM Warehouse - is usually NULL
RECVADDR_ID NUMBER

Receiving address for OPM - is usually NULL
SHIP_MTHD VARCHAR2 (4)
Ship method code from OPM derived from OPM-OP constant
SHIPPER_CODE VARCHAR2 (4)
Shipper code for OPM derived from Ship Via Lookup Code in Oracle Purchasing
OF_FRTBILL_MTHD VARCHAR2 (25)
Freight Bill Method in Oracle AP/Purchasing
OF_TERMS_CODE VARCHAR2 (50)
Payments Terms Code from Oracle AP/Purchasing
BILLING_CURRENCY VARCHAR2 (4)
Currency code on PO in Oracle Purchasing
PURCHASE_EXCHANGE_RATE NUMBER

Purchasing exchange rate from Oracle Purchasing
MUL_DIV_SIGN NUMBER (5)
Usually 0 to indicate multiplication of exchange rate
CURRENCY_BGHT_FWD NUMBER (5)
Defaults to 0; OPM indicator for Currency Bought Forward. 0 indicates that Purchasing exchange rate is not used in Receiving
POHOLD_CODE VARCHAR2 (4)
PO Hold code for OPM - usually NULL
CANCELLATION_CODE VARCHAR2 (4)
Cancellation code for cancelled PO's - NULL unless PO has been cancelled
FOB_CODE VARCHAR2 (4)
FOB Code in OPM; derived from FOB_LOOKUP_CODE in Oracle Purchasing
ICPURCH_CLASS VARCHAR2 (8)
Purchasing class in OPM - always NULL
VENDSO_NO VARCHAR2 (32)
Vendor sales order number for OPM; always NULL
PROJECT_NO VARCHAR2 (16)
Project number for OPM; always NULL
REQUESTED_DLVDATE DATE

Requested delivery date for OPM; mapped to PO_LINE_LOCATIONS.NEED_BY_DATE
SCHED_SHIPDATE DATE

Scheduled Ship Date in OPM; mapped from PO_LINE_LOCATIONS.PROMISED_DATE
REQUIRED_DLVDATE DATE

Required delivery date for OPM; mapped from PO_LINE_LOCATIONS.LAST_ACCEPT_DATE
AGREED_DLVDATE DATE

Agreed delivery date in OPM; mapped from PO_LINE_LOCATIONS.PROMISED_DATE. This date is written to the pending inventory transactions in OPM and is used by OPM MRP.
DATE_PRINTED DATE

Printed date of the PO from Oracle Purchasing
EXPEDITE_DATE DATE

Expedite date from OPM; usually NULL
REVISION_COUNT NUMBER (5)
Revision number from Oracle Purchasing
IN_USE NUMBER (10)
Column not used; holdover from OPM record locking mechanism
PRINT_COUNT NUMBER (5)
Print count from Oracle Purchasing
LINE_NO NUMBER (5)
Newly assigned line number for OPM
LINE_STATUS NUMBER

Status of PO line; 0 = open, 2 = closed, 1 = cancel
LINE_ID NUMBER (10)
Surrogate line id for OPM PO
BPO_LINE_ID NUMBER (10)
Surrogate line id for OPM BPO
APINV_LINE_ID NUMBER (10)
Column not used; defaults to NULL or 0
ITEM_NO VARCHAR2 (32)
OPM Item Number; taken from SEGMENT1 of MTL_SYSTEM_ITEMS
GENERIC_ID NUMBER (10)
Reference to generic item in OPM; no longer supported; defaults to 0 or NULL
ITEM_DESC VARCHAR2 (70)
Item description from OPM item master
ORDER_QTY1 NUMBER

Order qty from Oracle Purchasing (PO_LINE_LOCATIONS.QUANTITY)
ORDER_QTY2 NUMBER

Secondary order quantity for item which is dual-uom controlled; defaults from flexfield in Oracle Purchasing
ORDER_UM1 VARCHAR2 (4)
Unit of measure of order quantity from Oracle Purchasing; from UNIT_MEAS_LOOKUP_CODE
ORDER_UM2 VARCHAR2 (4)
Unit of measure for secondary quantity; same as item's secondary unit of measure
RECEIVED_QTY1 NUMBER

Quantity received on new PO is 0
RECEIVED_QTY2 NUMBER

Quantity received on new PO is 0
NET_PRICE NUMBER

Unit price from Oracle Purchasing (PO_LINES.UNIT_PRICE)
EXTENDED_PRICE NUMBER

Computed field which equals ORDER_QTY1 multiplied by NET_PRICE
PRICE_UM VARCHAR2 (4)
Same as ORDER_UM1
QC_GRADE_WANTED VARCHAR2 (4)
Optional field from Oracle Purchasing flexfield
MATCH_TYPE NUMBER

Defaults to 3
TEXT_CODE NUMBER (10)
Text code for OPM; always NULL
TRANS_CNT NUMBER (10)
Column no longer used in OPM
EXPORTED_DATE DATE

Column no longer used
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
DELETE_MARK NUMBER (5)
Mark for purge
INVALID_IND VARCHAR2 (1)
Status of interface row - N = Not Processed; Y = Processed, but failed validation; P = process successfully
REL_COUNT NUMBER

Release count - always 0
CONTRACT_NO VARCHAR2 (32)
Contract number in OPM; always NULL
CONTRACT_VALUE NUMBER

Contract value in OPM; always 0
CONTRACT_END_DATE DATE

Contract end date for Blanket Order in OPM; taken from END_DATE in Oracle Purchasing
CONTRACT_START_DATE DATE

Start date for Blanket Order in OPM; taken from START_DATE in Oracle Purchasing
AMOUNT_PURCHASED NUMBER

Amount Purchased against Blanket Order in OPM; always 0
ACTIVITY_IND NUMBER

Activity indicator for Blanket Order in OPM; always 0
CONTRACT_QTY NUMBER

Contract quantity in OPM; always 0
ITEM_UM VARCHAR2 (4)
Item unit of measure from UNIT_MEAS_LOOKUP_CODE
QTY_PURCHASED NUMBER

Quantity purchased in OPM; always 0
STD_QTY NUMBER

Standard release quantity for a Blanket Order in OPM; taken from QUANTITY in Oracle Purchasing
RELEASE_INTERVAL NUMBER

Release interval; defaulted to 1
BPO_STATUS NUMBER (5)
Status of Blanket Order; 0 = Open; 2 = Closed; 1 = Cancelled
BPOHOLD_CODE VARCHAR2 (4)
Blanket Order Hold Code; always NULL
CLOSURE_CODE VARCHAR2 (4)
Blanket Order Closure Code - always NULL
MAX_RELS_QTY NUMBER

Maximum release quantity; always equal to STD_QTY
ORGNADDR_ID NUMBER

Surrogate to OPM address table for organization; defaults to NULL
SOURCE_SHIPMENT_ID NUMBER

Defaults to 0
PURCH_CATEGORY_ID NUMBER

Category Id for PURCH_CLASS
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_ID
,      TRANSACTION_TYPE
,      ORGN_CODE
,      PO_NO
,      BPO_NO
,      PO_STATUS
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PO_RELEASE_ID
,      RELEASE_NUM
,      BUYER_CODE
,      PO_ID
,      BPO_ID
,      BPO_RELEASE_NUMBER
,      OF_PAYVEND_SITE_ID
,      OF_SHIPVEND_SITE_ID
,      PO_DATE
,      PO_TYPE
,      FROM_WHSE
,      TO_WHSE
,      RECV_DESC
,      RECV_LOCT
,      RECVADDR_ID
,      SHIP_MTHD
,      SHIPPER_CODE
,      OF_FRTBILL_MTHD
,      OF_TERMS_CODE
,      BILLING_CURRENCY
,      PURCHASE_EXCHANGE_RATE
,      MUL_DIV_SIGN
,      CURRENCY_BGHT_FWD
,      POHOLD_CODE
,      CANCELLATION_CODE
,      FOB_CODE
,      ICPURCH_CLASS
,      VENDSO_NO
,      PROJECT_NO
,      REQUESTED_DLVDATE
,      SCHED_SHIPDATE
,      REQUIRED_DLVDATE
,      AGREED_DLVDATE
,      DATE_PRINTED
,      EXPEDITE_DATE
,      REVISION_COUNT
,      IN_USE
,      PRINT_COUNT
,      LINE_NO
,      LINE_STATUS
,      LINE_ID
,      BPO_LINE_ID
,      APINV_LINE_ID
,      ITEM_NO
,      GENERIC_ID
,      ITEM_DESC
,      ORDER_QTY1
,      ORDER_QTY2
,      ORDER_UM1
,      ORDER_UM2
,      RECEIVED_QTY1
,      RECEIVED_QTY2
,      NET_PRICE
,      EXTENDED_PRICE
,      PRICE_UM
,      QC_GRADE_WANTED
,      MATCH_TYPE
,      TEXT_CODE
,      TRANS_CNT
,      EXPORTED_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      INVALID_IND
,      REL_COUNT
,      CONTRACT_NO
,      CONTRACT_VALUE
,      CONTRACT_END_DATE
,      CONTRACT_START_DATE
,      AMOUNT_PURCHASED
,      ACTIVITY_IND
,      CONTRACT_QTY
,      ITEM_UM
,      QTY_PURCHASED
,      STD_QTY
,      RELEASE_INTERVAL
,      BPO_STATUS
,      BPOHOLD_CODE
,      CLOSURE_CODE
,      MAX_RELS_QTY
,      ORGNADDR_ID
,      SOURCE_SHIPMENT_ID
,      PURCH_CATEGORY_ID
FROM GML.CPG_PURCHASING_INTERFACE;

Dependencies

[top of page]

GML.CPG_PURCHASING_INTERFACE does not reference any database object

GML.CPG_PURCHASING_INTERFACE is referenced by following:

SchemaGML
ViewCPG_PURCHASING_INTERFACE#