DBA Data[Home] [Help] [Dependency Information]

VIEW: BOM.CST_RCV_ACQ_COSTS#

Object Details
Object Name: CST_RCV_ACQ_COSTS#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes
COST_GROUP_ID NUMBER
Yes
COST_TYPE_ID NUMBER
Yes
PERIOD_ID NUMBER
Yes
RCV_TRANSACTION_ID NUMBER
Yes
NET_QUANTITY_RECEIVED NUMBER

TOTAL_QUANTITY_INVOICED NUMBER

QUANTITY_AT_PO_PRICE NUMBER

TOTAL_INVOICE_AMOUNT NUMBER

AMOUNT_AT_PO_PRICE NUMBER

TOTAL_AMOUNT NUMBER

COSTED_QUANTITY NUMBER

ACQUISITION_COST NUMBER

PO_LINE_LOCATION_ID NUMBER

PO_UNIT_PRICE NUMBER

PRIMARY_UOM VARCHAR2 (3)
REC_EXCHG_RATE NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT HEADER_ID
,      COST_GROUP_ID
,      COST_TYPE_ID
,      PERIOD_ID
,      RCV_TRANSACTION_ID
,      NET_QUANTITY_RECEIVED
,      TOTAL_QUANTITY_INVOICED
,      QUANTITY_AT_PO_PRICE
,      TOTAL_INVOICE_AMOUNT
,      AMOUNT_AT_PO_PRICE
,      TOTAL_AMOUNT
,      COSTED_QUANTITY
,      ACQUISITION_COST
,      PO_LINE_LOCATION_ID
,      PO_UNIT_PRICE
,      PRIMARY_UOM
,      REC_EXCHG_RATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM BOM.CST_RCV_ACQ_COSTS#;

Dependencies

[top of page]

BOM.CST_RCV_ACQ_COSTS# references the following:

SchemaBOM
TableCST_RCV_ACQ_COSTS
BOM.CST_RCV_ACQ_COSTS# is referenced by following:

SchemaAPPS
SynonymCST_RCV_ACQ_COSTS