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.

VIEW: APPS.CRP_FORM_QUERY_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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