View: MRPBV_BILL_OF_RESOURCE_REQS

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

View Text

SELECT REQ.BILL_OF_RESOURCES
, REQ.RESOURCE_DEPARTMENT_HOURS
, REQ.RESOURCE_UNITS
, REQ.SETBACK_DAYS
, REQ.ASSEMBLY_USAGE
, LKUP.MEANING
, LKUP2.MEANING
, REQ.RESOURCE_SEQ_NUM
, REQ.OPERATION_SEQ_NUM
, 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 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 '_SEC:REQ.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT REQ.BILL_OF_RESOURCES
, REQ.RESOURCE_DEPARTMENT_HOURS
, REQ.RESOURCE_UNITS
, REQ.SETBACK_DAYS
, REQ.ASSEMBLY_USAGE
, LKUP.MEANING
, LKUP2.MEANING
, REQ.RESOURCE_SEQ_NUM
, REQ.OPERATION_SEQ_NUM
, 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 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 '_SEC:REQ.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns