VIEW: APPS.MSC_RESOURCE_CHARGES_V

Source

View Text - Preformatted

SELECT mrc.res_transaction_id , mrc.plan_id , mrc.sr_instance_id , mrr.organization_id , mrr.transaction_id , msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id) , msc_get_name.department_code(decode(mrr.resource_id, -1, 1, 2), mrr.department_id, mrr.organization_id, mrr.plan_id,mrr.sr_instance_id) , msc_get_name.resource_code(mrr.resource_id,mrr.department_id, mrr.organization_id, mrr.plan_id,mrr.sr_instance_id) , NVL(mrr.firm_start_date,mrr.start_date) , NVL(mrr.firm_end_date,mrr.end_date) , NVL(NVL(ms.order_number,ms.wip_entity_name),TO_CHAR(ms.transaction_id)) , mrc.charge_number , mrc.charge_quantity , mrc.charge_start_datetime , mrc.charge_end_datetime FROM msc_resource_charges mrc , msc_resource_requirements mrr , msc_supplies ms WHERE mrc.plan_id = mrr.plan_id and mrc.sr_instance_id = mrr.sr_instance_id and mrc.res_transaction_id = mrr.transaction_id and ms.transaction_id = mrr.supply_id and ms.plan_id = mrr.plan_id

View Text - HTML Formatted

SELECT MRC.RES_TRANSACTION_ID
, MRC.PLAN_ID
, MRC.SR_INSTANCE_ID
, MRR.ORGANIZATION_ID
, MRR.TRANSACTION_ID
, MSC_GET_NAME.ORG_CODE(MRR.ORGANIZATION_ID
, MRR.SR_INSTANCE_ID)
, MSC_GET_NAME.DEPARTMENT_CODE(DECODE(MRR.RESOURCE_ID
, -1
, 1
, 2)
, MRR.DEPARTMENT_ID
, MRR.ORGANIZATION_ID
, MRR.PLAN_ID
, MRR.SR_INSTANCE_ID)
, MSC_GET_NAME.RESOURCE_CODE(MRR.RESOURCE_ID
, MRR.DEPARTMENT_ID
, MRR.ORGANIZATION_ID
, MRR.PLAN_ID
, MRR.SR_INSTANCE_ID)
, NVL(MRR.FIRM_START_DATE
, MRR.START_DATE)
, NVL(MRR.FIRM_END_DATE
, MRR.END_DATE)
, NVL(NVL(MS.ORDER_NUMBER
, MS.WIP_ENTITY_NAME)
, TO_CHAR(MS.TRANSACTION_ID))
, MRC.CHARGE_NUMBER
, MRC.CHARGE_QUANTITY
, MRC.CHARGE_START_DATETIME
, MRC.CHARGE_END_DATETIME
FROM MSC_RESOURCE_CHARGES MRC
, MSC_RESOURCE_REQUIREMENTS MRR
, MSC_SUPPLIES MS
WHERE MRC.PLAN_ID = MRR.PLAN_ID
AND MRC.SR_INSTANCE_ID = MRR.SR_INSTANCE_ID
AND MRC.RES_TRANSACTION_ID = MRR.TRANSACTION_ID
AND MS.TRANSACTION_ID = MRR.SUPPLY_ID
AND MS.PLAN_ID = MRR.PLAN_ID