[Home] [Help] [Dependency Information]
Object Name: | CSTFV_RCV_ACQ_COST_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.CSTFV_RCV_ACQ_COST_DETAILS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This shows the details of the periodic acquisition cost.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Yes | ||
DETAIL_ID | NUMBER | Yes | ||
SOURCE_TYPE | VARCHAR2 | (10) | ||
LEVEL_NUM | NUMBER | |||
AMOUNT | NUMBER | |||
QUANTITY | NUMBER | |||
PRICE | NUMBER | |||
LINE_TYPE | VARCHAR2 | (25) | ||
DISTRIBUTION_NUM | NUMBER | |||
COST_GROUP_NAME | VARCHAR2 | (10) | Yes | |
COST_TYPE_NAME | VARCHAR2 | (10) | Yes | |
PAC_PERIOD_NAME | VARCHAR2 | (15) | Yes | |
RECEIVING_TXN_TYPE | VARCHAR2 | (25) | Yes | |
RECEIVING_TXN_DATE | DATE | Yes | ||
IMMED_PARENT_INVOICE_NUM | VARCHAR2 | (50) | ||
INVOICE_NUMBER | VARCHAR2 | (50) | ||
TOP_PARENT_INVOICE_NUM | VARCHAR2 | (50) | ||
IMMED_PARENT_DIST_LINE_NUM | NUMBER | (15) | ||
DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | ||
TOP_PARENT_DIST_LINE_NUM | NUMBER | (15) | ||
PO_LINE_NUMBER | NUMBER | |||
PO_NUMBER | VARCHAR2 | (20) | ||
SHIPMENT_NUMBER | NUMBER | |||
MATCH_OPTION | VARCHAR2 | (7) | ||
SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
SHIP_TO_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
PO_LINE_LOCATION_ID | NUMBER | |||
PARENT_DISTRIBUTION_ID | NUMBER | |||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | ||
PARENT_INVOICE_DIST_ID | NUMBER | |||
COST_GROUP_ID | NUMBER | Yes | ||
COST_TYPE_ID | NUMBER | Yes | ||
PAC_PERIOD_ID | NUMBER | Yes | ||
RCV_TRANSACTION_ID | NUMBER | Yes | ||
TOP_PARENT_INVOICE_ID | NUMBER | (15) | ||
INVOICE_ID | NUMBER | (15) | ||
IMMED_PARENT_INVOICE_ID | NUMBER | (15) | ||
PO_HEADER_ID | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
UPDATED_BY | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, DETAIL_ID
, SOURCE_TYPE
, LEVEL_NUM
, AMOUNT
, QUANTITY
, PRICE
, LINE_TYPE
, DISTRIBUTION_NUM
, COST_GROUP_NAME
, COST_TYPE_NAME
, PAC_PERIOD_NAME
, RECEIVING_TXN_TYPE
, RECEIVING_TXN_DATE
, IMMED_PARENT_INVOICE_NUM
, INVOICE_NUMBER
, TOP_PARENT_INVOICE_NUM
, IMMED_PARENT_DIST_LINE_NUM
, DISTRIBUTION_LINE_NUMBER
, TOP_PARENT_DIST_LINE_NUM
, PO_LINE_NUMBER
, PO_NUMBER
, SHIPMENT_NUMBER
, MATCH_OPTION
, SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_ORGANIZATION_NAME
, PO_LINE_LOCATION_ID
, PARENT_DISTRIBUTION_ID
, INVOICE_DISTRIBUTION_ID
, PARENT_INVOICE_DIST_ID
, COST_GROUP_ID
, COST_TYPE_ID
, PAC_PERIOD_ID
, RCV_TRANSACTION_ID
, TOP_PARENT_INVOICE_ID
, INVOICE_ID
, IMMED_PARENT_INVOICE_ID
, PO_HEADER_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, UPDATED_BY
FROM APPS.CSTFV_RCV_ACQ_COST_DETAILS;
APPS.CSTFV_RCV_ACQ_COST_DETAILS is not referenced by any database object
|
|
|