VIEW: APPS.MRPBV_BILL_OF_RESOURCE_REQS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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