VIEW: APPS.MSC_FLP_RES_ATP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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