VIEW: APPS.MRPFV_BILL_OF_RESOURCE_REQS

Source

View Text - Preformatted

SELECT PARA.ORGANIZATION_CODE ,ORG.NAME ,REQ.BILL_OF_RESOURCES ,'_KF:INV:MSTK:SYSITEM' ,'_KF:INV:MSTK:COMP' ,DEPT.DEPARTMENT_CODE ,RES.RESOURCE_CODE ,REQ.RESOURCE_SEQ_NUM ,REQ.OPERATION_SEQ_NUM ,NULL ,REQ.RESOURCE_DEPARTMENT_HOURS ,REQ.RESOURCE_UNITS ,REQ.SETBACK_DAYS ,REQ.ASSEMBLY_USAGE ,LKUP.MEANING ,LKUP2.MEANING ,'_DF:CRP:CRP_RESOURCE_HOURS:REQ' ,REQ.TRANSACTION_ID ,REQ.ORGANIZATION_ID ,REQ.ASSEMBLY_ITEM_ID ,REQ.DEPARTMENT_ID ,REQ.RESOURCE_ID ,REQ.LINE_ID ,REQ.SOURCE_ITEM_ID ,REQ.OPERATION_SEQUENCE_ID ,REQ.LAST_UPDATE_DATE ,REQ.LAST_UPDATED_BY ,REQ.CREATION_DATE ,REQ.CREATED_BY FROM MTL_PARAMETERS PARA, HR_ALL_ORGANIZATION_UNITS ORG, MTL_SYSTEM_ITEMS SYSITEM, MTL_SYSTEM_ITEMS COMP, MFG_LOOKUPS LKUP, MFG_LOOKUPS LKUP2, BOM_DEPARTMENTS DEPT, BOM_RESOURCES RES, CRP_RESOURCE_HOURS REQ WHERE REQ.DEPARTMENT_ID IS NOT NULL AND LKUP.LOOKUP_TYPE(+) = 'CST_BASIS' AND REQ.BASIS = LKUP.LOOKUP_CODE(+) AND LKUP2.LOOKUP_TYPE = 'CRP_ROLLUP_ORIGINATION' AND REQ.ORIGINATION_TYPE = LKUP2.LOOKUP_CODE AND REQ.DEPARTMENT_ID = DEPT.DEPARTMENT_ID AND REQ.RESOURCE_ID = RES.RESOURCE_ID AND REQ.ORGANIZATION_ID = PARA.ORGANIZATION_ID AND REQ.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND REQ.ORGANIZATION_ID = SYSITEM.ORGANIZATION_ID AND REQ.ASSEMBLY_ITEM_ID = SYSITEM.INVENTORY_ITEM_ID AND REQ.ORGANIZATION_ID = COMP.ORGANIZATION_ID(+) AND REQ.SOURCE_ITEM_ID = COMP.INVENTORY_ITEM_ID(+) AND '_SEC:REQ.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT PARA.ORGANIZATION_CODE ,ORG.NAME ,REQ.BILL_OF_RESOURCES ,'_KF:INV:MSTK:SYSITEM' ,'_KF:INV:MSTK:COMP' ,NULL ,NULL ,REQ.RESOURCE_SEQ_NUM ,REQ.OPERATION_SEQ_NUM ,LINE.LINE_CODE ,REQ.RESOURCE_DEPARTMENT_HOURS ,REQ.RESOURCE_UNITS ,REQ.SETBACK_DAYS ,REQ.ASSEMBLY_USAGE ,LKUP.MEANING ,LKUP2.MEANING ,'_DF:CRP:CRP_RESOURCE_HOURS:REQ' ,REQ.TRANSACTION_ID ,REQ.ORGANIZATION_ID ,REQ.ASSEMBLY_ITEM_ID ,TO_NUMBER(NULL) ,TO_NUMBER(NULL) ,REQ.LINE_ID ,REQ.SOURCE_ITEM_ID ,REQ.OPERATION_SEQUENCE_ID ,REQ.LAST_UPDATE_DATE ,REQ.LAST_UPDATED_BY ,REQ.CREATION_DATE ,REQ.CREATED_BY FROM MTL_PARAMETERS para, HR_ALL_ORGANIZATION_UNITS org, MTL_SYSTEM_ITEMS SYSITEM, MTL_SYSTEM_ITEMS COMP, MFG_LOOKUPS LKUP, MFG_LOOKUPS LKUP2, WIP_LINES LINE, CRP_RESOURCE_HOURS REQ WHERE REQ.LINE_ID IS NOT NULL AND LKUP.LOOKUP_TYPE(+) = 'CST_BASIS' AND REQ.BASIS = LKUP.LOOKUP_CODE(+) AND LKUP2.LOOKUP_TYPE = 'CRP_ROLLUP_ORIGINATION' AND REQ.ORIGINATION_TYPE = LKUP2.LOOKUP_CODE AND REQ.ORGANIZATION_ID = LINE.ORGANIZATION_ID AND REQ.LINE_ID = LINE.LINE_ID AND REQ.ORGANIZATION_ID = PARA.ORGANIZATION_ID AND REQ.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND REQ.ORGANIZATION_ID = SYSITEM.ORGANIZATION_ID AND REQ.ASSEMBLY_ITEM_ID = SYSITEM.INVENTORY_ITEM_ID AND REQ.ORGANIZATION_ID = COMP.ORGANIZATION_ID(+) AND REQ.SOURCE_ITEM_ID = COMP.INVENTORY_ITEM_ID(+) AND '_SEC:REQ.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PARA.ORGANIZATION_CODE
, ORG.NAME
, REQ.BILL_OF_RESOURCES
, '_KF:INV:MSTK:SYSITEM'
, '_KF:INV:MSTK:COMP'
, DEPT.DEPARTMENT_CODE
, RES.RESOURCE_CODE
, REQ.RESOURCE_SEQ_NUM
, REQ.OPERATION_SEQ_NUM
, NULL
, REQ.RESOURCE_DEPARTMENT_HOURS
, REQ.RESOURCE_UNITS
, REQ.SETBACK_DAYS
, REQ.ASSEMBLY_USAGE
, LKUP.MEANING
, LKUP2.MEANING
, '_DF:CRP:CRP_RESOURCE_HOURS:REQ'
, REQ.TRANSACTION_ID
, REQ.ORGANIZATION_ID
, REQ.ASSEMBLY_ITEM_ID
, REQ.DEPARTMENT_ID
, REQ.RESOURCE_ID
, REQ.LINE_ID
, REQ.SOURCE_ITEM_ID
, REQ.OPERATION_SEQUENCE_ID
, REQ.LAST_UPDATE_DATE
, REQ.LAST_UPDATED_BY
, REQ.CREATION_DATE
, REQ.CREATED_BY
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_SYSTEM_ITEMS SYSITEM
, MTL_SYSTEM_ITEMS COMP
, MFG_LOOKUPS LKUP
, MFG_LOOKUPS LKUP2
, BOM_DEPARTMENTS DEPT
, BOM_RESOURCES RES
, CRP_RESOURCE_HOURS REQ
WHERE REQ.DEPARTMENT_ID IS NOT NULL
AND LKUP.LOOKUP_TYPE(+) = 'CST_BASIS'
AND REQ.BASIS = LKUP.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE = 'CRP_ROLLUP_ORIGINATION'
AND REQ.ORIGINATION_TYPE = LKUP2.LOOKUP_CODE
AND REQ.DEPARTMENT_ID = DEPT.DEPARTMENT_ID
AND REQ.RESOURCE_ID = RES.RESOURCE_ID
AND REQ.ORGANIZATION_ID = PARA.ORGANIZATION_ID
AND REQ.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND REQ.ORGANIZATION_ID = SYSITEM.ORGANIZATION_ID
AND REQ.ASSEMBLY_ITEM_ID = SYSITEM.INVENTORY_ITEM_ID
AND REQ.ORGANIZATION_ID = COMP.ORGANIZATION_ID(+)
AND REQ.SOURCE_ITEM_ID = COMP.INVENTORY_ITEM_ID(+)
AND '_SEC:REQ.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT PARA.ORGANIZATION_CODE
, ORG.NAME
, REQ.BILL_OF_RESOURCES
, '_KF:INV:MSTK:SYSITEM'
, '_KF:INV:MSTK:COMP'
, NULL
, NULL
, REQ.RESOURCE_SEQ_NUM
, REQ.OPERATION_SEQ_NUM
, LINE.LINE_CODE
, REQ.RESOURCE_DEPARTMENT_HOURS
, REQ.RESOURCE_UNITS
, REQ.SETBACK_DAYS
, REQ.ASSEMBLY_USAGE
, LKUP.MEANING
, LKUP2.MEANING
, '_DF:CRP:CRP_RESOURCE_HOURS:REQ'
, REQ.TRANSACTION_ID
, REQ.ORGANIZATION_ID
, REQ.ASSEMBLY_ITEM_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, REQ.LINE_ID
, REQ.SOURCE_ITEM_ID
, REQ.OPERATION_SEQUENCE_ID
, REQ.LAST_UPDATE_DATE
, REQ.LAST_UPDATED_BY
, REQ.CREATION_DATE
, REQ.CREATED_BY
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_SYSTEM_ITEMS SYSITEM
, MTL_SYSTEM_ITEMS COMP
, MFG_LOOKUPS LKUP
, MFG_LOOKUPS LKUP2
, WIP_LINES LINE
, CRP_RESOURCE_HOURS REQ
WHERE REQ.LINE_ID IS NOT NULL
AND LKUP.LOOKUP_TYPE(+) = 'CST_BASIS'
AND REQ.BASIS = LKUP.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE = 'CRP_ROLLUP_ORIGINATION'
AND REQ.ORIGINATION_TYPE = LKUP2.LOOKUP_CODE
AND REQ.ORGANIZATION_ID = LINE.ORGANIZATION_ID
AND REQ.LINE_ID = LINE.LINE_ID
AND REQ.ORGANIZATION_ID = PARA.ORGANIZATION_ID
AND REQ.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND REQ.ORGANIZATION_ID = SYSITEM.ORGANIZATION_ID
AND REQ.ASSEMBLY_ITEM_ID = SYSITEM.INVENTORY_ITEM_ID
AND REQ.ORGANIZATION_ID = COMP.ORGANIZATION_ID(+)
AND REQ.SOURCE_ITEM_ID = COMP.INVENTORY_ITEM_ID(+)
AND '_SEC:REQ.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY