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: ViewBOM.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 Mandatory 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:

SchemaAPPS
ViewCST_ORGANIZATION_DEFINITIONS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMTL_SYSTEM_ITEMS_VL
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_HEADERS
SynonymPO_LINES
SynonymPO_LINE_LOCATIONS
SynonymPO_RELEASES
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymRCV_ACCOUNTING_EVENTS
SynonymRCV_ACCOUNTING_EVENT_TYPES
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS

APPS.CST_RCV_RAE_V is not referenced by any database object