View: CST_PM_PENDING_TXN_V

Product:	BOM - Bills of Material
Description:	Identifies material and WIP transactions that have not been cost collected or have errored out in cost collection
Implementation/DBA Data:	APPS.CST_PM_PENDING_TXN_V

View Text

SELECT CPMTV.PROJECT_ID
, CPMTV.TASK_ID
, CPMTV.ORGANIZATION_ID
, CPMTV.TRANSACTION_ID
, TO_CHAR(NULL)
, CPMTV.TRANSACTION_DATE
, 1
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCNR'
, NULL
, 'R')
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCNR'
, NULL
, 'A')
, 'CCNR' EXCEPTION_CODE
FROM CST_PM_MATL_TXN_V CPMTV
WHERE CPMTV.PM_COST_COLLECTED = 'N' AND CPMTV.PROJECT_ID IS NOT NULL UNION SELECT CPMTV.TO_PROJECT_ID
, CPMTV.TO_TASK_ID
, CPMTV.ORGANIZATION_ID
, CPMTV.TRANSACTION_ID
, TO_CHAR(NULL)
, CPMTV.TRANSACTION_DATE
, 1
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCNR'
, NULL
, 'R ')
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCNR'
, NULL
, 'A ')
, 'CCNR' EXCEPTION_CODE
FROM CST_PM_MATL_TXN_V CPMTV
WHERE CPMTV.PM_COST_COLLECTED = 'N' AND CPMTV.TRANSACTION_ACTION_ID IN (2
, 3) AND CPMTV.TO_PROJECT_ID IS NOT NULL UNION SELECT CPMTV.SOURCE_PROJECT_ID
, CPMTV.SOURCE_TASK_ID
, CPMTV.ORGANIZATION_ID
, CPMTV.TRANSACTION_ID
, TO_CHAR(NULL)
, CPMTV.TRANSACTION_DATE
, 1
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCNR'
, NULL
, 'R ')
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCNR'
, NULL
, 'A ')
, 'CCNR' EXCEPTION_CODE
FROM CST_PM_MATL_TXN_V CPMTV
WHERE CPMTV.PM_COST_COLLECTED = 'N' AND ( (CPMTV.TRANSACTION_ACTION_ID IN (1
, 27
, 31
, 32
, 33
, 34) AND CPMTV.TRANSACTION_SOURCE_TYPE_ID = 5) OR (CPMTV.TYPE_CLASS = 1) ) AND CPMTV.SOURCE_PROJECT_ID IS NOT NULL UNION SELECT MMT.PROJECT_ID
, MMT.TASK_ID
, MMT.ORGANIZATION_ID
, MMT.TRANSACTION_ID
, TO_CHAR(NULL)
, MMT.TRANSACTION_DATE
, 1
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCERR'
, NULL
, 'R')
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCERR'
, NULL
, 'A')
, 'CCERR' EXCEPTION_CODE
FROM MTL_MATERIAL_TRANSACTIONS MMT
WHERE MMT.PM_COST_COLLECTED = 'E' AND MMT.PROJECT_ID IS NOT NULL
AND MMT.ACTUAL_COST <> 0 UNION SELECT MMT.SOURCE_PROJECT_ID
, MMT.SOURCE_TASK_ID
, MMT.ORGANIZATION_ID
, MMT.TRANSACTION_ID
, TO_CHAR(NULL)
, MMT.TRANSACTION_DATE
, 1
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCERR'
, NULL
, 'R')
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCERR'
, NULL
, 'A')
, 'CCERR' EXCEPTION_CODE
FROM MTL_MATERIAL_TRANSACTIONS MMT
WHERE MMT.PM_COST_COLLECTED = 'E' AND MMT.SOURCE_PROJECT_ID IS NOT NULL
AND MMT.ACTUAL_COST <> 0 UNION SELECT MMT.TO_PROJECT_ID
, MMT.TO_TASK_ID
, MMT.ORGANIZATION_ID
, MMT.TRANSACTION_ID
, TO_CHAR(NULL)
, MMT.TRANSACTION_DATE
, 1
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCERR'
, NULL
, 'R')
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCERR'
, NULL
, 'A')
, 'CCERR' EXCEPTION_CODE
FROM MTL_MATERIAL_TRANSACTIONS MMT
WHERE MMT.PM_COST_COLLECTED = 'E' AND MMT.TO_PROJECT_ID IS NOT NULL
AND MMT.ACTUAL_COST <> 0 UNION SELECT WT.PROJECT_ID
, WT.TASK_ID
, WT.ORGANIZATION_ID
, WT.TRANSACTION_ID
, TO_CHAR(NULL)
, WT.TRANSACTION_DATE
, 2
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCNR'
, NULL
, 'R ')
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCNR'
, NULL
, 'A ')
, 'CCNR' EXCEPTION_CODE
FROM WIP_TRANSACTIONS WT
WHERE WT.PM_COST_COLLECTED = 'N' AND WT.TRANSACTION_TYPE IN (1
, 2
, 3) AND WT.PROJECT_ID IS NOT NULL AND EXISTS ( SELECT NULL
FROM WIP_TRANSACTION_ACCOUNTS WTA WHERE WTA.TRANSACTION_ID = WT.TRANSACTION_ID ) UNION SELECT WT.PROJECT_ID
, WT.TASK_ID
, WT.ORGANIZATION_ID
, WT.TRANSACTION_ID
, TO_CHAR(NULL)
, WT.TRANSACTION_DATE
, 2
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCERR'
, NULL
, 'R')
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('MFG_EXCP'
, 'CCERR'
, NULL
, 'A')
, 'CCERR' EXCEPTION_CODE
FROM WIP_TRANSACTIONS WT
WHERE WT.PM_COST_COLLECTED = 'E'

Columns