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_ADJ

Object Details

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

This table stores the header ID and other information at the header level for the Periodic Cost Adjustment process. It also stores the MMT transaction ID if there is a Periodic Cost update transaction created in MMT. The child table to this table is the CST_RCV_ACQ_COST_DETAILS_ADJ table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_RCV_ACQ_COSTS_ADJ_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HEADER_ID
CST_RCV_ACQ_COSTS_ADJ_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_GROUP_ID COST_TYPE_ID RCV_TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
HEADER_ID	NUMBER		Yes	Header ID for each row
COST_GROUP_ID	NUMBER		Yes	Cost Group ID that refers to the Cost Group
COST_TYPE_ID	NUMBER		Yes	Cost Type ID that refers to the Cost Type
PERIOD_ID	NUMBER		Yes	The PAC Period ID
RCV_TRANSACTION_ID	NUMBER		Yes	The Transaction ID of the parent Receipt
NET_QUANTITY_RECEIVED	NUMBER			The Net quantity Received for the receipt
TOTAL_QUANTITY_INVOICED	NUMBER			Total Quantity Invoiced
QUANTITY_AT_PO_PRICE	NUMBER			The quantity considered for acquisition cost at PO price
TOTAL_INVOICE_AMOUNT	NUMBER			The Total Invoice Amount
AMOUNT_AT_PO_PRICE	NUMBER			The Total amount at PO price
TOTAL_AMOUNT	NUMBER			Sum of Invoiced amount and amount at PO Price
COSTED_QUANTITY	NUMBER			The total costed quantity considered for the Acquisition Cost
ACQUISITION_COST	NUMBER			The Acquisition Cost for the item
PO_LINE_LOCATION_ID	NUMBER			The Purchase order line location ID
PO_UNIT_PRICE	NUMBER			The unit price on the PO
PRIMARY_UOM	VARCHAR2	(3)		The primary unit of measure
REC_EXCHG_RATE	NUMBER			The exchange rate
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
LAST_UPDATED_BY	NUMBER		Yes	Last Updated By
CREATION_DATE	DATE		Yes	Creation Date
CREATED_BY	NUMBER		Yes	Created By
REQUEST_ID	NUMBER			Request ID of the Periodic Acquisition Cost adjustment process
PROGRAM_APPLICATION_ID	NUMBER			The Program Application ID
PROGRAM_ID	NUMBER			The Program ID
PROGRAM_UPDATE_DATE	DATE			Program Update Date
LAST_UPDATE_LOGIN	NUMBER			The last Update Login ID
MMT_TRANSACTION_ID	NUMBER			The transaction ID of the Update transaction in MMT

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
,      MMT_TRANSACTION_ID
FROM BOM.CST_RCV_ACQ_COSTS_ADJ;

Dependencies

[top of page]

BOM.CST_RCV_ACQ_COSTS_ADJ does not reference any database object

BOM.CST_RCV_ACQ_COSTS_ADJ is referenced by following:

APPS: CST_RCV_ACQ_COSTS_ADJ