Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_FLP_RES_V |
SELECT REQ.PLAN_ID
, REQ.SUPPLY_ID
, REQ.SR_INSTANCE_ID
, NVL(REQ.ROUTING_SEQUENCE_ID
, -23453)
, REQ.OPERATION_SEQUENCE_ID
, REQ.ORGANIZATION_ID
, MTP.ORGANIZATION_CODE
, REQ.DEPARTMENT_ID
, DEPT_RES.DEPARTMENT_CODE
, REQ.RESOURCE_ID
, DEPT_RES.RESOURCE_CODE
, REQ.START_DATE
, REQ.END_DATE
, NVL(REQ.RESOURCE_HOURS
, REQ.LOAD_RATE)
, DEPT_RES.DEPARTMENT_DESCRIPTION
, DEPT_RES.RESOURCE_DESCRIPTION
, DEPT_RES.BATCHABLE_FLAG
FROM MSC_RESOURCE_REQUIREMENTS REQ
, MSC_TRADING_PARTNERS MTP
, MSC_DEPARTMENT_RESOURCES DEPT_RES
WHERE REQ.ORGANIZATION_ID = MTP.SR_TP_ID
AND REQ.SR_INSTANCE_ID = MTP.SR_INSTANCE_ID
AND MTP.PARTNER_TYPE = 3
AND REQ.PLAN_ID = DEPT_RES.PLAN_ID
AND REQ.SR_INSTANCE_ID = DEPT_RES.SR_INSTANCE_ID
AND REQ.ORGANIZATION_ID = DEPT_RES.ORGANIZATION_ID
AND REQ.DEPARTMENT_ID = DEPT_RES.DEPARTMENT_ID
AND REQ.RESOURCE_ID = DEPT_RES.RESOURCE_ID
AND NVL(PARENT_ID
, 2) = 2