[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
BOM.CST_RCV_ACQ_COSTS_ADJ does not reference any database object
BOM.CST_RCV_ACQ_COSTS_ADJ is referenced by following:
|
|
|