Product: | CRP - Capacity |
---|---|
Description: | View of detailed resource requirements |
Implementation/DBA Data: | APPS.CRP_FORM_QUERY_V |
SELECT CFQ.ROWID
, CFQ.QUERY_ID
, CFQ.NUMBER11
, BD.DEPARTMENT_CODE
, CFQ.NUMBER12
, BR.RESOURCE_CODE
, CFQ.NUMBER13
, WL.LINE_CODE
, CFQ.NUMBER14
, CFQ.DATE1
, CFQ.DATE2
, CFQ.DATE3
, CFQ.DATE4
, CFQ.CHAR1
, DECODE(L2.LOOKUP_CODE
, NULL
, 2
, L2.LOOKUP_CODE)
, CFQ.NUMBER1
, CFQ.NUMBER2
, CFQ.NUMBER2
, CFQ.NUMBER3
, CFQ.NUMBER4
, L1.MEANING
, L1.MEANING
, WE.WIP_ENTITY_NAME
, IIF1.ITEM_NUMBER
, DECODE(CFQ.NUMBER8
, NULL
, NULL
, IIF2.ITEM_NUMBER)
, CFQ.NUMBER7
, CFQ.NUMBER8
, CFQ.LAST_UPDATE_DATE
, CFQ.LAST_UPDATED_BY
, CFQ.CREATION_DATE
, CFQ.CREATED_BY
, CFQ.LAST_UPDATE_LOGIN
, CFQ.REQUEST_ID
, CFQ.PROGRAM_APPLICATION_ID
, CFQ.PROGRAM_ID
, CFQ.PROGRAM_UPDATE_DATE
FROM MFG_LOOKUPS L2
, MFG_LOOKUPS L1
, WIP_ENTITIES WE
, MTL_ITEM_FLEXFIELDS IIF1
, MTL_ITEM_FLEXFIELDS IIF2
, BOM_DEPARTMENTS BD
, BOM_RESOURCES BR
, WIP_LINES WL
, CRP_FORM_QUERY CFQ
WHERE L2.MEANING(+) = CFQ.CHAR2
AND L2.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND L1.LOOKUP_CODE(+) = CFQ.NUMBER5
AND L1.LOOKUP_TYPE(+) = DECODE(TO_CHAR(NUMBER9)
, TO_CHAR(1)
, 'CRP_REQUIREMENTS_TYPE'
, TO_CHAR(2)
, 'MRP_ORDER_TYPE'
, 'CRP_REQUIREMENTS_TYPE')
AND WE.WIP_ENTITY_ID(+) = CFQ.NUMBER6
AND WE.ORGANIZATION_ID(+) = CFQ.NUMBER11
AND WL.LINE_ID(+) = CFQ.NUMBER14
AND WL.ORGANIZATION_ID (+) = CFQ.NUMBER11
AND BR.RESOURCE_ID(+) = CFQ.NUMBER13
AND BD.DEPARTMENT_ID(+) = CFQ.NUMBER12
AND IIF1.INVENTORY_ITEM_ID = CFQ.NUMBER7
AND IIF1.ORGANIZATION_ID = CFQ.NUMBER11
AND IIF2.INVENTORY_ITEM_ID = NVL(CFQ.NUMBER8
, CFQ.NUMBER7)
AND IIF2.ORGANIZATION_ID = CFQ.NUMBER11