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]

TABLE: BOM.CST_RCV_ACQ_COSTS

Object Details

Object Name:	CST_RCV_ACQ_COSTS
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_RCV_ACQ_COSTS
Subobject Name:
Status:	VALID

Stores Periodic Acquisition Cost Summary for each receipt for an organization cost group and cost type

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_RCV_ACQ_COSTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HEADER_ID
CST_RCV_ACQ_COSTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_GROUP_ID COST_TYPE_ID RCV_TRANSACTION_ID
CST_RCV_ACQ_COSTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_ID COST_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
HEADER_ID	NUMBER		Yes	Unique Identifier
COST_GROUP_ID	NUMBER		Yes	Cost Group Identifier
COST_TYPE_ID	NUMBER		Yes	Cost Type Identifier
PERIOD_ID	NUMBER		Yes	Period (for the Cost Type) of the receipt
RCV_TRANSACTION_ID	NUMBER		Yes	Receipt Identifier from RCV_TRANSACTIONS
NET_QUANTITY_RECEIVED	NUMBER			Net Quantity Received (net of corrections and returns)
TOTAL_QUANTITY_INVOICED	NUMBER			Sum of the quantity invoiced for the invoices matched to the receipt
QUANTITY_AT_PO_PRICE	NUMBER			Portion of the Net Quantity Received that was not Invoiced (and is costed at the PO Price)
TOTAL_INVOICE_AMOUNT	NUMBER			Sum of the Invoice Amounts for the Invoices matched to the Receipt
AMOUNT_AT_PO_PRICE	NUMBER			Amount derived using Uninvoiced Quantity at PO Price
TOTAL_AMOUNT	NUMBER			Sum of the Invoice Amount and PO Amount
COSTED_QUANTITY	NUMBER			Quantity used to compute the per unit Acquisition Cost. This will be the Net Quantity Received or the Total Quantity Invoiced, whichever is greater
ACQUISITION_COST	NUMBER			Per Unit Periodic Acquisition Cost
PO_LINE_LOCATION_ID	NUMBER			Shipment Line Number for the receipt
PO_UNIT_PRICE	NUMBER			Per Unit PO price inclusive of non recoverable tax, based on primary UOM of the item
PRIMARY_UOM	VARCHAR2	(3)		Per Unit PO price inclusive of non recoverable tax, based on primary UOM of the item
REC_EXCHG_RATE	NUMBER			Currency Conversion rate.
LAST_UPDATE_DATE	DATE		Yes	Who column
LAST_UPDATED_BY	NUMBER		Yes	Who column
CREATION_DATE	DATE		Yes	Who column
CREATED_BY	NUMBER		Yes	Who column
REQUEST_ID	NUMBER			Who column
PROGRAM_APPLICATION_ID	NUMBER			Who column
PROGRAM_ID	NUMBER			Who column
PROGRAM_UPDATE_DATE	DATE			Who column
LAST_UPDATE_LOGIN	NUMBER			Who column

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 does not reference any database object

BOM.CST_RCV_ACQ_COSTS is referenced by following:

APPS: CST_RCV_ACQ_COSTS