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.

[Home] [Help]

View: CST_AP_VARIANCE_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_AP_VARIANCE_V

View Text

SELECT CAVH.BATCH_ID BATCH_ID
, CAVB.DESCRIPTION
, CAVB.ADJUSTMENT_ACCOUNT ADJUSTMENT_ACCOUNT
, CAVL.PROJECT_ID PROJECT_ID
, PPA.SEGMENT1 PROJECT_NUMBER
, OOD.ORGANIZATION_CODE ORGANIZATION_CODE
, OOD.ORGANIZATION_CODE ORGANIZATION_NAME
, CCG.COST_GROUP COST_GROUP
, CAVH.VARIANCE_HEADER_ID VARIANCE_HEADER_ID
, CAVL.VARIANCE_LINE_ID VARIANCE_LINE_ID
, CAVH.TRANSACTION_DATE ORIG_TRANSACTION_DATE
, MTI.TRANSACTION_DATE TRANSACTION_DATE
, CQL.LAYER_QUANTITY CURRENT_QUANTITY
, CQL.ITEM_COST CURRENT_ITEM_COST
, MTCDI.VALUE_CHANGE VALUE_CHANGE
, (MTCDI.VALUE_CHANGE/(CQL.LAYER_QUANTITY * CQL.ITEM_COST) )*100 PCNT_VALUE_CHANGE
, PHA.SEGMENT1 PO_NUMBER
, PLA.LINE_NUM PO_LINE_NUM
, AIA.INVOICE_NUM INVOICE_NUM
, CAVL.DISTRIBUTION_LINE_NUMBER INVOICE_DIST_LINE_NUM
, PDA.DISTRIBUTION_NUM PO_DISTRIBUTION_NUM
, CAVH.VAR_AMOUNT HEADER_VAR_AMOUNT
, CAVL.VAR_AMOUNT LINE_VAR_AMOUNT
, CAVH.ORGANIZATION_ID ORGANIZATION_ID
, CAVH.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CAVH.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, PDA.ACCRUAL_ACCOUNT_ID
FROM CST_AP_VARIANCE_HEADERS CAVH
, CST_AP_VARIANCE_LINES CAVL
, CST_AP_VARIANCE_BATCHES CAVB
, CST_QUANTITY_LAYERS CQL
, PO_DISTRIBUTIONS PDA
, PO_LINE_LOCATIONS_ALL PLLA
, PO_LINES_ALL PLA
, PO_HEADERS_ALL PHA
, PA_PROJECTS_ALL PPA
, CST_COST_GROUPS CCG
, ORG_ORGANIZATION_DEFINITIONS OOD
, MTL_TRANSACTIONS_INTERFACE MTI
, MTL_TXN_COST_DET_INTERFACE MTCDI
, AP_INVOICES_ALL AIA
WHERE CAVL.VARIANCE_HEADER_ID = CAVH.VARIANCE_HEADER_ID
AND CAVB.BATCH_ID = CAVH.BATCH_ID
AND CQL.INVENTORY_ITEM_ID = CAVH.INVENTORY_ITEM_ID
AND CQL.ORGANIZATION_ID = CAVH.ORGANIZATION_ID
AND CQL.COST_GROUP_ID = CAVH.COST_GROUP_ID
AND PDA.PO_DISTRIBUTION_ID = CAVH.PO_DISTRIBUTION_ID
AND PLLA.LINE_LOCATION_ID = PDA.LINE_LOCATION_ID
AND PLA.PO_LINE_ID = PLLA.PO_LINE_ID
AND PHA.PO_HEADER_ID = PLLA.PO_HEADER_ID
AND PPA.PROJECT_ID (+) = CAVL.PROJECT_ID
AND CCG.COST_GROUP_ID = CAVH.COST_GROUP_ID
AND OOD.ORGANIZATION_ID = CAVH.ORGANIZATION_ID
AND MTI.SOURCE_CODE = 'VARIANCE TRF'
AND MTI.SOURCE_HEADER_ID = CAVH.BATCH_ID
AND MTI.SOURCE_LINE_ID = CAVH.VARIANCE_HEADER_ID
AND MTCDI.TRANSACTION_INTERFACE_ID = MTI.TRANSACTION_INTERFACE_ID
AND MTCDI.LEVEL_TYPE = 1
AND MTCDI.COST_ELEMENT_ID = 1
AND AIA.INVOICE_ID = CAVL.INVOICE_ID

Columns

Name
BATCH_ID
BATCH_DESCRIPTION
ADJUSTMENT_ACCOUNT
PROJECT_ID
PROJECT_NUMBER
ORGANIZATION_CODE
ORGANIZATION_NAME
COST_GROUP
VARIANCE_HEADER_ID
VARIANCE_LINE_ID
ORIG_TRANSACTION_DATE
TRANSACTION_DATE
CURRENT_QUANTITY
CURRENT_ITEM_COST
VALUE_CHANGE
PCNT_VALUE_CHANGE
PO_NUMBER
PO_LINE_NUM
INVOICE_NUM
INVOICE_DIST_LINE_NUM
PO_DISTRIBUTION_NUM
HEADER_VAR_AMOUNT
LINE_VAR_AMOUNT
ORGANIZATION_ID
INVENTORY_ITEM_ID
PO_DISTRIBUTION_ID
PO_DIST_ACCOUNT