eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: GML.CPG_PURCHASING_INTERFACE#

Object Details

Object Name:	CPG_PURCHASING_INTERFACE#
Object Type:	VIEW
Owner:	GML
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TRANSACTION_ID	NUMBER		Yes
TRANSACTION_TYPE	VARCHAR2	(10)	Yes
ORGN_CODE	VARCHAR2	(4)
PO_NO	VARCHAR2	(32)	Yes
BPO_NO	VARCHAR2	(32)
PO_STATUS	VARCHAR2	(25)
PO_HEADER_ID	NUMBER
PO_LINE_ID	NUMBER
PO_LINE_LOCATION_ID	NUMBER
PO_DISTRIBUTION_ID	NUMBER
PO_RELEASE_ID	NUMBER
RELEASE_NUM	NUMBER
BUYER_CODE	VARCHAR2	(35)
PO_ID	NUMBER	(10)
BPO_ID	NUMBER	(10)
BPO_RELEASE_NUMBER	NUMBER
OF_PAYVEND_SITE_ID	NUMBER
OF_SHIPVEND_SITE_ID	NUMBER
PO_DATE	DATE
PO_TYPE	NUMBER
FROM_WHSE	VARCHAR2	(4)
TO_WHSE	VARCHAR2	(4)
RECV_DESC	VARCHAR2	(40)
RECV_LOCT	VARCHAR2	(16)
RECVADDR_ID	NUMBER
SHIP_MTHD	VARCHAR2	(4)
SHIPPER_CODE	VARCHAR2	(4)
OF_FRTBILL_MTHD	VARCHAR2	(25)
OF_TERMS_CODE	VARCHAR2	(50)
BILLING_CURRENCY	VARCHAR2	(4)
PURCHASE_EXCHANGE_RATE	NUMBER
MUL_DIV_SIGN	NUMBER	(5)
CURRENCY_BGHT_FWD	NUMBER	(5)
POHOLD_CODE	VARCHAR2	(4)
CANCELLATION_CODE	VARCHAR2	(4)
FOB_CODE	VARCHAR2	(4)
ICPURCH_CLASS	VARCHAR2	(8)
VENDSO_NO	VARCHAR2	(32)
PROJECT_NO	VARCHAR2	(16)
REQUESTED_DLVDATE	DATE
SCHED_SHIPDATE	DATE
REQUIRED_DLVDATE	DATE
AGREED_DLVDATE	DATE
DATE_PRINTED	DATE
EXPEDITE_DATE	DATE
REVISION_COUNT	NUMBER	(5)
IN_USE	NUMBER	(10)
PRINT_COUNT	NUMBER	(5)
LINE_NO	NUMBER	(5)
LINE_STATUS	NUMBER
LINE_ID	NUMBER	(10)
BPO_LINE_ID	NUMBER	(10)
APINV_LINE_ID	NUMBER	(10)
ITEM_NO	VARCHAR2	(32)
GENERIC_ID	NUMBER	(10)
ITEM_DESC	VARCHAR2	(70)
ORDER_QTY1	NUMBER
ORDER_QTY2	NUMBER
ORDER_UM1	VARCHAR2	(4)
ORDER_UM2	VARCHAR2	(4)
RECEIVED_QTY1	NUMBER
RECEIVED_QTY2	NUMBER
NET_PRICE	NUMBER
EXTENDED_PRICE	NUMBER
PRICE_UM	VARCHAR2	(4)
QC_GRADE_WANTED	VARCHAR2	(4)
MATCH_TYPE	NUMBER
TEXT_CODE	NUMBER	(10)
TRANS_CNT	NUMBER	(10)
EXPORTED_DATE	DATE
LAST_UPDATE_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
DELETE_MARK	NUMBER	(5)
INVALID_IND	VARCHAR2	(1)
REL_COUNT	NUMBER
CONTRACT_NO	VARCHAR2	(32)
CONTRACT_VALUE	NUMBER
CONTRACT_END_DATE	DATE
CONTRACT_START_DATE	DATE
AMOUNT_PURCHASED	NUMBER
ACTIVITY_IND	NUMBER
CONTRACT_QTY	NUMBER
ITEM_UM	VARCHAR2	(4)
QTY_PURCHASED	NUMBER
STD_QTY	NUMBER
RELEASE_INTERVAL	NUMBER
BPO_STATUS	NUMBER	(5)
BPOHOLD_CODE	VARCHAR2	(4)
CLOSURE_CODE	VARCHAR2	(4)
MAX_RELS_QTY	NUMBER
ORGNADDR_ID	NUMBER
SOURCE_SHIPMENT_ID	NUMBER
PURCH_CATEGORY_ID	NUMBER

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# references the following:

GML: CPG_PURCHASING_INTERFACE

GML.CPG_PURCHASING_INTERFACE# is referenced by following:

APPS: CPG_PURCHASING_INTERFACE