VIEW: APPS.MSC_BILL_OF_RESOURCES_V

Source

View Text - Preformatted

SELECT req.plan_id, req.bill_of_resources, bor.description, bor.disable_date, bor.rollup_start_date, bor.rollup_completion_date, req.sr_instance_id, req.transaction_id, req.assembly_item_id, items1.item_name, req.source_item_id, items2.item_name, req.organization_id, org1.organization_code, req.resource_id, dept.resource_code, req.department_id, dept.department_code, req.resource_department_hours, req.operation_seq_num, req.operation_sequence_id, req.resource_seq_num, req.setback_days, req.assembly_usage, req.origination_type, l1.meaning, req.resource_units, req.basis, req.sr_transaction_id, req.last_update_date, req.last_updated_by, req.creation_date, req.created_by, req.last_update_login from msc_items items1, msc_items items2, mfg_lookups l1, msc_trading_partners org1, msc_department_resources dept, msc_bill_of_resources bor, msc_bor_requirements req WHERE items1.inventory_item_id = req.assembly_item_id AND items2.inventory_item_id = req.source_item_id AND l1.lookup_code = req.origination_type AND l1.lookup_type = 'CRP_ROLLUP_ORIGINATION' AND org1.sr_tp_id = req.organization_id AND org1.sr_instance_id = req.sr_instance_id AND org1.partner_type = 3 AND dept.plan_id = -1 AND dept.organization_id = req.organization_id AND dept.sr_instance_id = req.sr_instance_id AND dept.department_id = req.department_id AND dept.resource_id = NVL(req.resource_id,-1) AND bor.plan_id = req.plan_id AND bor.organization_id = req.organization_id AND bor.sr_instance_id = req.sr_instance_id AND bor.bill_of_resources = req.bill_of_resources

View Text - HTML Formatted

SELECT REQ.PLAN_ID
, REQ.BILL_OF_RESOURCES
, BOR.DESCRIPTION
, BOR.DISABLE_DATE
, BOR.ROLLUP_START_DATE
, BOR.ROLLUP_COMPLETION_DATE
, REQ.SR_INSTANCE_ID
, REQ.TRANSACTION_ID
, REQ.ASSEMBLY_ITEM_ID
, ITEMS1.ITEM_NAME
, REQ.SOURCE_ITEM_ID
, ITEMS2.ITEM_NAME
, REQ.ORGANIZATION_ID
, ORG1.ORGANIZATION_CODE
, REQ.RESOURCE_ID
, DEPT.RESOURCE_CODE
, REQ.DEPARTMENT_ID
, DEPT.DEPARTMENT_CODE
, REQ.RESOURCE_DEPARTMENT_HOURS
, REQ.OPERATION_SEQ_NUM
, REQ.OPERATION_SEQUENCE_ID
, REQ.RESOURCE_SEQ_NUM
, REQ.SETBACK_DAYS
, REQ.ASSEMBLY_USAGE
, REQ.ORIGINATION_TYPE
, L1.MEANING
, REQ.RESOURCE_UNITS
, REQ.BASIS
, REQ.SR_TRANSACTION_ID
, REQ.LAST_UPDATE_DATE
, REQ.LAST_UPDATED_BY
, REQ.CREATION_DATE
, REQ.CREATED_BY
, REQ.LAST_UPDATE_LOGIN
FROM MSC_ITEMS ITEMS1
, MSC_ITEMS ITEMS2
, MFG_LOOKUPS L1
, MSC_TRADING_PARTNERS ORG1
, MSC_DEPARTMENT_RESOURCES DEPT
, MSC_BILL_OF_RESOURCES BOR
, MSC_BOR_REQUIREMENTS REQ
WHERE ITEMS1.INVENTORY_ITEM_ID = REQ.ASSEMBLY_ITEM_ID
AND ITEMS2.INVENTORY_ITEM_ID = REQ.SOURCE_ITEM_ID
AND L1.LOOKUP_CODE = REQ.ORIGINATION_TYPE
AND L1.LOOKUP_TYPE = 'CRP_ROLLUP_ORIGINATION'
AND ORG1.SR_TP_ID = REQ.ORGANIZATION_ID
AND ORG1.SR_INSTANCE_ID = REQ.SR_INSTANCE_ID
AND ORG1.PARTNER_TYPE = 3
AND DEPT.PLAN_ID = -1
AND DEPT.ORGANIZATION_ID = REQ.ORGANIZATION_ID
AND DEPT.SR_INSTANCE_ID = REQ.SR_INSTANCE_ID
AND DEPT.DEPARTMENT_ID = REQ.DEPARTMENT_ID
AND DEPT.RESOURCE_ID = NVL(REQ.RESOURCE_ID
, -1)
AND BOR.PLAN_ID = REQ.PLAN_ID
AND BOR.ORGANIZATION_ID = REQ.ORGANIZATION_ID
AND BOR.SR_INSTANCE_ID = REQ.SR_INSTANCE_ID
AND BOR.BILL_OF_RESOURCES = REQ.BILL_OF_RESOURCES