APPS.MSC_GANTT_UTILS dependencies on MSC_ITEMS

Line 3278: msc_items mi,

3274: mrr.department_id, mrr.resource_id, mrr.supply_id) res_overload
3275: from msc_resource_requirements mrr,
3276: msc_department_resources mdr,
3277: msc_supplies ms,
3278: msc_items mi,
3279: msc_items mi2,
3280: msc_gantt_query mgq,
3281: msc_plan_organizations mpo,
3282: msc_plans mp

Line 3279: msc_items mi2,

3275: from msc_resource_requirements mrr,
3276: msc_department_resources mdr,
3277: msc_supplies ms,
3278: msc_items mi,
3279: msc_items mi2,
3280: msc_gantt_query mgq,
3281: msc_plan_organizations mpo,
3282: msc_plans mp
3283: where mgq.query_id = p_query_id

Line 3399: msc_items mi,

3395: from msc_resource_instance_reqs mrir,
3396: msc_resource_requirements mrr,
3397: msc_department_resources mdr,
3398: msc_supplies ms,
3399: msc_items mi,
3400: msc_items mi2,
3401: msc_gantt_query mgq
3402: where mgq.query_id = p_query_id
3403: and mgq.row_flag = SYS_YES

Line 3400: msc_items mi2,

3396: msc_resource_requirements mrr,
3397: msc_department_resources mdr,
3398: msc_supplies ms,
3399: msc_items mi,
3400: msc_items mi2,
3401: msc_gantt_query mgq
3402: where mgq.query_id = p_query_id
3403: and mgq.row_flag = SYS_YES
3404: and ( ( p_batched_res_act = RES_REQ_ROW_TYPE )

Line 8493: from msc_items

8489: select nvl(v_demand_quantity,0) qty,
8490: nvl(to_char(v_demand_date,format_mask), null_space) demand_date,
8491: msc_get_name.lookup_meaning('MRP_FLP_SUPPLY_DEMAND_TYPE', v_demand_id) type,
8492: item_name item
8493: from msc_items
8494: where inventory_item_id = v_item_id;
8495:
8496: cursor demand is
8497: select md.using_requirement_quantity qty,

Line 10367: msc_items mi,

10363: mgq.critical_flag
10364: from msc_resource_requirements mrr,
10365: msc_department_resources mdr,
10366: msc_supplies ms,
10367: msc_items mi,
10368: msc_items mi2,
10369: msc_trading_partners mtp,
10370: msc_gantt_query mgq
10371: where mgq.query_id = :p_query_id

Line 10368: msc_items mi2,

10364: from msc_resource_requirements mrr,
10365: msc_department_resources mdr,
10366: msc_supplies ms,
10367: msc_items mi,
10368: msc_items mi2,
10369: msc_trading_partners mtp,
10370: msc_gantt_query mgq
10371: where mgq.query_id = :p_query_id
10372: and mgq.node_type = :RES_NODE