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_RCV_RAE_V

Object Details

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

View on the Receiving Accounting events table. Selects information related to the receiving accounting event along with details of the receiving transaction, inventory organization, purchase order document, shipment, vendor etc

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Unique Row Identifier
ORGANIZATION_ID	NUMBER		Organization in which the accounting event is being generated
OPERATING_UNIT_ID	NUMBER		Operating Unit in which the event is being generated
ORGANIZATION_NAME	VARCHAR2	(240)	Name of Inventory Organization
ORG_CODE	VARCHAR2	(3)	Code of Inventory Organization
SET_OF_BOOKS_ID	NUMBER	(15)	Set Of Books Identifier
TRANSACTION_ID	NUMBER		Receiving Transaction Unique Identifier
ACCOUNTING_EVENT_ID	NUMBER		Accounting Event Unique Identifier
EVENT_TYPE_ID	NUMBER		Accounting Event Type Identifier
EVENT_TYPE_NAME	VARCHAR2	(240)	Accounting Event Type Name
TRANSACTION_DATE	DATE		Transaction date
TRANSACTION_QUANTITY	NUMBER		Transaction Quantity
TRANSACTION_UOM	VARCHAR2	(3)	Transaction Unit of Measure
PRIMARY_QUANTITY	NUMBER		Transaction quantity in item's primary unit of measure.
PRIMARY_UOM_CODE	VARCHAR2	(3)	Item primary unit of measure
PO_HEADER_ID	NUMBER		Purchase Order Header Unique Identifier
PO_HEADER_NUM	VARCHAR2	(50)	Purchase Order Number
PO_LINE_ID	NUMBER		Purchase Order Line Unique Identifier
PO_LINE_NUM	VARCHAR2	(240)	PO LIne Number
PO_DISTRIBUTION_ID	NUMBER		Purchase Order Distribution Unique Identifier
PO_RELEASE_ID	NUMBER		Purchase Order Release Unique Identifier
RELEASE_NUM	NUMBER		Release Number
REQUISITION_ID	NUMBER		Requisition header unique identifier
REQUISITION_NUM	VARCHAR2	(20)	Requisition Number
REQUISITION_LINE_ID	NUMBER		Requisition line unique identifier
REQUISITION_LINE_NUM	NUMBER		Requisition line number
PO_VENDOR_ID	NUMBER		Supplier unique identifier
PO_VENDOR_NAME	VARCHAR2	(240)	Supplier name
PO_VENDOR_SITE_ID	NUMBER		Supplier site unique identifier
PO_VENDOR_SITE_NAME	VARCHAR2	(15)	Supplier site name
RECEIPT_NUM	VARCHAR2	(30)	Receipt number
SHIPMENT_NUM	VARCHAR2	(30)	Shipment number assigned by the shipment's source
SHIPMENT_HEADER_ID	NUMBER		Receipt header unique identifier
RECEIPT_LINE_NUM	NUMBER		Receipt line number
SHIPMENT_LINE_ID	NUMBER		Shipment line unique identifier
RECEIVING_LOCATION_ID	NUMBER		Receiving location unique identifier
INVENTORY_ITEM_ID	NUMBER		Item unique identifier
ITEM_DESCRIPTION	VARCHAR2	(240)	Item description
REVISION	VARCHAR2	(3)	Item revision
UNIT_PRICE	NUMBER		Unit Price in PO unit of measure. Could be PO price or transfer price
PRIOR_UNIT_PRICE	NUMBER		Prior unit price. Used only for retroactive pricing and landed cost adjustment events
UNIT_LANDED_COST	NUMBER		Landed cost of the LCM shipment
INTERCOMPANY_PRICING_OPTION	NUMBER		Flag that indicates if Unit Price is at PO price or Transfer Price. 1-PO price 2-Transfer price
TRANSACTION_AMOUNT	NUMBER		Transaction Amount. Used only for service line types
NR_TAX	NUMBER		Non-recoverable Tax
REC_TAX	NUMBER		Recoverable Tax
NR_TAX_AMOUNT	NUMBER		Nonrecoverable tax amount. Used for service line types.
REC_TAX_AMOUNT	NUMBER		Recoverable tax amount. Used only for service line types.
PRIOR_NR_TAX	NUMBER		Prior non-recoverable tax. Only applicable for retroactive pricing.
PRIOR_REC_TAX	NUMBER		Prior recoverable tax. Only applicable for retroactive pricing.
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)	Currency Conversion Type
CURRENCY_CONVERSION_RATE	NUMBER		Currency Conversion Rate
CURRENCY_CONVERSION_DATE	DATE		Currency Conversion date
ACCOUNTED_FLAG	VARCHAR2	(1)	Flag that indicates if accounting entries have been created for the accounting event
PROCUREMENT_ORG_FLAG	VARCHAR2	(1)	Flag that indicates if event is for the supplier facing operating unit
CROSS_OU_FLAG	VARCHAR2	(1)	Flag that indicates if transaction is for a PO that crosses operating units
TRX_FLOW_HEADER_ID	NUMBER		Identifier of the transaction flow being used for the event. Only applicable for Shared Services scenarios.
INVOICED_FLAG	VARCHAR2	(1)	Flag that indicates if the event has been processed by the Intercompany invoicing program. Only applicable to invoice match and invoice reversal events.
PA_ADDITION_FLAG	VARCHAR2	(1)	Flag that indicates if project related receipts have been transferred to projects
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
REQUEST_ID	NUMBER		Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Who column
PROGRAM_ID	NUMBER		Concurrent Who column
PROGRAM_UPDATE_DATE	DATE		Concurrent Who column

Query Text

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


SELECT ROW_ID
,      ORGANIZATION_ID
,      OPERATING_UNIT_ID
,      ORGANIZATION_NAME
,      ORG_CODE
,      SET_OF_BOOKS_ID
,      TRANSACTION_ID
,      ACCOUNTING_EVENT_ID
,      EVENT_TYPE_ID
,      EVENT_TYPE_NAME
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      PO_HEADER_ID
,      PO_HEADER_NUM
,      PO_LINE_ID
,      PO_LINE_NUM
,      PO_DISTRIBUTION_ID
,      PO_RELEASE_ID
,      RELEASE_NUM
,      REQUISITION_ID
,      REQUISITION_NUM
,      REQUISITION_LINE_ID
,      REQUISITION_LINE_NUM
,      PO_VENDOR_ID
,      PO_VENDOR_NAME
,      PO_VENDOR_SITE_ID
,      PO_VENDOR_SITE_NAME
,      RECEIPT_NUM
,      SHIPMENT_NUM
,      SHIPMENT_HEADER_ID
,      RECEIPT_LINE_NUM
,      SHIPMENT_LINE_ID
,      RECEIVING_LOCATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      REVISION
,      UNIT_PRICE
,      PRIOR_UNIT_PRICE
,      UNIT_LANDED_COST
,      INTERCOMPANY_PRICING_OPTION
,      TRANSACTION_AMOUNT
,      NR_TAX
,      REC_TAX
,      NR_TAX_AMOUNT
,      REC_TAX_AMOUNT
,      PRIOR_NR_TAX
,      PRIOR_REC_TAX
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ACCOUNTED_FLAG
,      PROCUREMENT_ORG_FLAG
,      CROSS_OU_FLAG
,      TRX_FLOW_HEADER_ID
,      INVOICED_FLAG
,      PA_ADDITION_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.CST_RCV_RAE_V;

Dependencies

[top of page]

APPS.CST_RCV_RAE_V references the following:

APPS: CST_ORGANIZATION_DEFINITIONS; FND_GLOBAL - show dependent code; MTL_SYSTEM_ITEMS_VL; MTL_UNITS_OF_MEASURE; PO_HEADERS; PO_LINES; PO_LINE_LOCATIONS; PO_RELEASES; PO_REQUISITION_HEADERS; PO_REQUISITION_LINES; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_ACCOUNTING_EVENTS; RCV_ACCOUNTING_EVENT_TYPES; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.CST_RCV_RAE_V is not referenced by any database object