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: APPS.CST_PAC_RECEIVING_VALUES_V

Object Details

Object Name:	CST_PAC_RECEIVING_VALUES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_PAC_RECEIVING_VALUES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes
TRANSACTION_DATE	DATE		Yes
TXN_ORGANIZATION_ID	NUMBER
LEGAL_ENTITY	NUMBER
COST_GROUP_ID	NUMBER		Yes
MASTER_ORGANIZATION_ID	NUMBER		Yes
MASTER_ORG_UOM	VARCHAR2	(3)
ITEM_ID	NUMBER
ITEM_REVISION	VARCHAR2	(3)
ITEM_DESCRIPTION	VARCHAR2	(240)
TXN_UNIT_OF_MEASURE	VARCHAR2	(25)	Yes
LOCATION_ID	NUMBER
TO_ORGANIZATION_ID	NUMBER
TO_ORG_PRIMARY_QUANTITY	NUMBER
TO_ORG_PRIMARY_UOM	VARCHAR2	(25)
RECEIPT_DATE	DATE
RECEIPT_NUM	VARCHAR2	(30)
SHIPMENT_NUM	VARCHAR2	(30)
SHIPPED_DATE	DATE
FREIGHT_CARRIER_CODE	VARCHAR2	(25)
QUANTITY_SHIPPED	NUMBER
DESTINATION_TYPE_CODE	VARCHAR2	(25)
PACKING_SLIP	VARCHAR2	(25)
SOURCE_DOCUMENT_CODE	VARCHAR2	(25)
DELIVER_TO_LOCATION_ID	NUMBER
SOURCE_DOCUMENT	VARCHAR2	(30)
DOCUMENT_LINE_NUM	NUMBER
ACQUISITION_COST	NUMBER
VENDOR_ID	NUMBER
RCV_TRANSACTION_ID	NUMBER
PERIOD_ID	NUMBER		Yes	Period ID

Query Text

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


SELECT TRANSACTION_ID
,      TRANSACTION_DATE
,      TXN_ORGANIZATION_ID
,      LEGAL_ENTITY
,      COST_GROUP_ID
,      MASTER_ORGANIZATION_ID
,      MASTER_ORG_UOM
,      ITEM_ID
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      TXN_UNIT_OF_MEASURE
,      LOCATION_ID
,      TO_ORGANIZATION_ID
,      TO_ORG_PRIMARY_QUANTITY
,      TO_ORG_PRIMARY_UOM
,      RECEIPT_DATE
,      RECEIPT_NUM
,      SHIPMENT_NUM
,      SHIPPED_DATE
,      FREIGHT_CARRIER_CODE
,      QUANTITY_SHIPPED
,      DESTINATION_TYPE_CODE
,      PACKING_SLIP
,      SOURCE_DOCUMENT_CODE
,      DELIVER_TO_LOCATION_ID
,      SOURCE_DOCUMENT
,      DOCUMENT_LINE_NUM
,      ACQUISITION_COST
,      VENDOR_ID
,      RCV_TRANSACTION_ID
,      PERIOD_ID
FROM APPS.CST_PAC_RECEIVING_VALUES_V;

Dependencies

[top of page]

APPS.CST_PAC_RECEIVING_VALUES_V references the following:

APPS: CST_COST_GROUPS; CST_COST_GROUP_ASSIGNMENTS; CST_PAC_PERIODS; CST_RCV_ACQ_COSTS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_SUPPLY; RCV_TRANSACTIONS

APPS.CST_PAC_RECEIVING_VALUES_V is not referenced by any database object