[Home] [Help] [Dependency Information]
Object Name: | CST_RCV_RAE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.CST_RCV_RAE_V |
Subobject Name: | |
Status: | VALID |
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.
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 | (20) | Purchase Order Number | |
PO_LINE_ID | NUMBER | Purchase Order Line Unique Identifier | ||
PO_LINE_NUM | NUMBER | 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 |
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;
APPS.CST_RCV_RAE_V is not referenced by any database object
|
|
|