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_XLA_INV_REF_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REF_TRANSACTION_ID	NUMBER		Yes	Transaction identifier
TRANSACTION_QUANTITY	NUMBER		Yes	Transaction quantity
TRANSACTION_UOM	VARCHAR2	(3)	Yes	Transaction unit of measure
TRANSACTION_SOURCE_ID	NUMBER			Transaction source identifier
TRANSACTION_SOURCE_NAME	VARCHAR2	(80)		Transaction source identfier
TRANSACTION_REFERENCE	VARCHAR2	(240)		Transaction reference code
REASON_ID	NUMBER			Transaction reason identifier
ENCUMBRANCE_AMOUNT	NUMBER			Total encumbrance amount
PPV_VARIANCE_AMOUNT	NUMBER			Used for average cost update transactions
DEPARTMENT_ID	NUMBER			Department identifier
OPERATION_SEQ_NUM	NUMBER			Operation sequence number within a routing
TRX_SOURCE_LINE_ID	NUMBER			Line level transaction source id
PHYSICAL_ADJUSTMENT_ID	NUMBER			Physical adjustment identifier
CYCLE_COUNT_ID	NUMBER			Cycle count identifier
TRANSFER_TRANSACTION_ID	NUMBER			Transaction id of the opposing transfer transaction
RCV_TRANSACTION_ID	NUMBER			Receiving transaction cross reference
MOVE_TRANSACTION_ID	NUMBER			Move transaction cross reference
COMPLETION_TRANSACTION_ID	NUMBER			Completion transaction cross reference
SHIPMENT_NUMBER	VARCHAR2	(30)		Intransit shipment identifier
TRANSFER_COST	NUMBER			Transfer cost specified for inter-org transfers
TRANSPORTATION_COST	NUMBER			Transfer transportation cost
WAYBILL_AIRBILL	VARCHAR2	(20)		Airbill / waybill number
FREIGHT_CODE	VARCHAR2	(30)		Intransit shipment freight code
TRANSACTION_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
PA_EXPENDITURE_ORG_ID	NUMBER			Oracle Projects related expenditure organization identifier
EXPENDITURE_TYPE	VARCHAR2	(30)		Oracle Projects related expenditure type
FINAL_COMPLETION_FLAG	VARCHAR2	(1)
TRANSFER_PERCENTAGE	NUMBER
PICK_SLIP_NUMBER	NUMBER
FOB_POINT	NUMBER
PARENT_TRANSACTION_ID	NUMBER
LOGICAL_TRX_TYPE_CODE	NUMBER
LOGICAL_TRANSACTION	VARCHAR2	(1)
INTERCOMPANY_PRICING_OPTION	NUMBER
COGS_RECOG_PERCENT_CHANGE	NUMBER
COGS_PERCENTAGE	NUMBER
ENCUMBRANCE_REVERSAL_AMOUNT	NUMBER
ENCUM_REVERSAL_AMOUNT_ENTERED	NUMBER
TXN_SHIPMENT_HEADER_ID	NUMBER
TXN_SHIPMENT_LINE_ID	NUMBER
APPLIED_TO_APPL_ID	NUMBER
APPLIED_TO_ENTITY_CODE	VARCHAR2	(14)
APPLIED_TO_DIST_LINK_TYPE	CHAR	(20)
TXN_PO_HEADER_ID	NUMBER
TXN_PO_DISTRIBUTION_ID	NUMBER
BUS_FLOW_REQ_ENTITY_CODE	CHAR	(11)
BUS_FLOW_REQ_DIST_TYPE	CHAR	(24)
BUS_FLOW_REQ_DIST_ID	NUMBER
BUS_FLOW_REQ_ID	NUMBER
PERCENTAGE_CHANGE	NUMBER
VALUE_CHANGE	NUMBER
REPETITIVE_LINE_ID	NUMBER
APPLIED_TO_PO_DOC_ID	NUMBER
INV_TXN_DISTRIBUTION_ACCT	NUMBER
INV_TXN_TRANSPO_DIST_ACCT	NUMBER
INV_TXN_EXPENSE_ACCT	NUMBER
INV_TXN_MATERIAL_ACCT	NUMBER
INV_TXN_MAT_OVHD_ACCT	NUMBER
INV_TXN_OUT_PROC_ACCT	NUMBER
INV_TXN_OVERHEAD_ACCT	NUMBER
INV_TXN_RESOURCE_ACCT	NUMBER

Query Text

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


SELECT REF_TRANSACTION_ID
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_REFERENCE
,      REASON_ID
,      ENCUMBRANCE_AMOUNT
,      PPV_VARIANCE_AMOUNT
,      DEPARTMENT_ID
,      OPERATION_SEQ_NUM
,      TRX_SOURCE_LINE_ID
,      PHYSICAL_ADJUSTMENT_ID
,      CYCLE_COUNT_ID
,      TRANSFER_TRANSACTION_ID
,      RCV_TRANSACTION_ID
,      MOVE_TRANSACTION_ID
,      COMPLETION_TRANSACTION_ID
,      SHIPMENT_NUMBER
,      TRANSFER_COST
,      TRANSPORTATION_COST
,      WAYBILL_AIRBILL
,      FREIGHT_CODE
,      TRANSACTION_ATTRIBUTE1
,      TRANSACTION_ATTRIBUTE2
,      TRANSACTION_ATTRIBUTE3
,      TRANSACTION_ATTRIBUTE4
,      TRANSACTION_ATTRIBUTE5
,      TRANSACTION_ATTRIBUTE6
,      TRANSACTION_ATTRIBUTE7
,      TRANSACTION_ATTRIBUTE8
,      TRANSACTION_ATTRIBUTE9
,      TRANSACTION_ATTRIBUTE10
,      TRANSACTION_ATTRIBUTE11
,      TRANSACTION_ATTRIBUTE12
,      TRANSACTION_ATTRIBUTE13
,      TRANSACTION_ATTRIBUTE14
,      TRANSACTION_ATTRIBUTE15
,      PA_EXPENDITURE_ORG_ID
,      EXPENDITURE_TYPE
,      FINAL_COMPLETION_FLAG
,      TRANSFER_PERCENTAGE
,      PICK_SLIP_NUMBER
,      FOB_POINT
,      PARENT_TRANSACTION_ID
,      LOGICAL_TRX_TYPE_CODE
,      LOGICAL_TRANSACTION
,      INTERCOMPANY_PRICING_OPTION
,      COGS_RECOG_PERCENT_CHANGE
,      COGS_PERCENTAGE
,      ENCUMBRANCE_REVERSAL_AMOUNT
,      ENCUM_REVERSAL_AMOUNT_ENTERED
,      TXN_SHIPMENT_HEADER_ID
,      TXN_SHIPMENT_LINE_ID
,      APPLIED_TO_APPL_ID
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_DIST_LINK_TYPE
,      TXN_PO_HEADER_ID
,      TXN_PO_DISTRIBUTION_ID
,      BUS_FLOW_REQ_ENTITY_CODE
,      BUS_FLOW_REQ_DIST_TYPE
,      BUS_FLOW_REQ_DIST_ID
,      BUS_FLOW_REQ_ID
,      PERCENTAGE_CHANGE
,      VALUE_CHANGE
,      REPETITIVE_LINE_ID
,      APPLIED_TO_PO_DOC_ID
,      INV_TXN_DISTRIBUTION_ACCT
,      INV_TXN_TRANSPO_DIST_ACCT
,      INV_TXN_EXPENSE_ACCT
,      INV_TXN_MATERIAL_ACCT
,      INV_TXN_MAT_OVHD_ACCT
,      INV_TXN_OUT_PROC_ACCT
,      INV_TXN_OVERHEAD_ACCT
,      INV_TXN_RESOURCE_ACCT
FROM APPS.CST_XLA_INV_REF_V;

Dependencies

[top of page]

APPS.CST_XLA_INV_REF_V references the following:

APPS: CST_COGS_EVENTS; MTL_MATERIAL_TRANSACTIONS; MTL_TRANSACTION_ACCOUNTS; PO_REQUISITION_LINES_ALL; RCV_TRANSACTIONS

APPS.CST_XLA_INV_REF_V is referenced by following:

APPS: XLA_00707_AAD_S_000002_PKG - show dependent code; XLA_00707_AAD_S_000005_BC_PKG - show dependent code; XLA_00707_AAD_S_000005_PKG - show dependent code; XLA_00707_AAD_S_000007_BC_PKG - show dependent code; XLA_00707_AAD_S_000007_PKG - show dependent code; XLA_00707_AAD_S_000019_PKG - show dependent code; XLA_00707_AAD_S_000020_BC_PKG - show dependent code; XLA_00707_AAD_S_000020_PKG - show dependent code