View: MSC_BILL_OF_RESOURCES_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_BILL_OF_RESOURCES_V

View Text

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

Columns