View: MRPFV_BILL_OF_RESOURCE_REQS

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPFV_BILL_OF_RESOURCE_REQS

View Text

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

Columns