APPS.MSC_GANTT_UTILS dependencies on MSC_ITEMS

Line 3273: msc_items mi,

3269: mrr.department_id, mrr.resource_id, mrr.supply_id) res_overload
3270: from msc_resource_requirements mrr,
3271: msc_department_resources mdr,
3272: msc_supplies ms,
3273: msc_items mi,
3274: msc_items mi2,
3275: msc_gantt_query mgq,
3276: msc_plan_organizations mpo,
3277: msc_plans mp

Line 3274: msc_items mi2,

3270: from msc_resource_requirements mrr,
3271: msc_department_resources mdr,
3272: msc_supplies ms,
3273: msc_items mi,
3274: msc_items mi2,
3275: msc_gantt_query mgq,
3276: msc_plan_organizations mpo,
3277: msc_plans mp
3278: where mgq.query_id = p_query_id

Line 3394: msc_items mi,

3390: from msc_resource_instance_reqs mrir,
3391: msc_resource_requirements mrr,
3392: msc_department_resources mdr,
3393: msc_supplies ms,
3394: msc_items mi,
3395: msc_items mi2,
3396: msc_gantt_query mgq
3397: where mgq.query_id = p_query_id
3398: and mgq.row_flag = SYS_YES

Line 3395: msc_items mi2,

3391: msc_resource_requirements mrr,
3392: msc_department_resources mdr,
3393: msc_supplies ms,
3394: msc_items mi,
3395: msc_items mi2,
3396: msc_gantt_query mgq
3397: where mgq.query_id = p_query_id
3398: and mgq.row_flag = SYS_YES
3399: and ( ( p_batched_res_act = RES_REQ_ROW_TYPE )

Line 8488: from msc_items

8484: select nvl(v_demand_quantity,0) qty,
8485: nvl(to_char(v_demand_date,format_mask), null_space) demand_date,
8486: msc_get_name.lookup_meaning('MRP_FLP_SUPPLY_DEMAND_TYPE', v_demand_id) type,
8487: item_name item
8488: from msc_items
8489: where inventory_item_id = v_item_id;
8490:
8491: cursor demand is
8492: select md.using_requirement_quantity qty,

Line 10362: msc_items mi,

10358: mgq.critical_flag
10359: from msc_resource_requirements mrr,
10360: msc_department_resources mdr,
10361: msc_supplies ms,
10362: msc_items mi,
10363: msc_items mi2,
10364: msc_trading_partners mtp,
10365: msc_gantt_query mgq
10366: where mgq.query_id = :p_query_id

Line 10363: msc_items mi2,

10359: from msc_resource_requirements mrr,
10360: msc_department_resources mdr,
10361: msc_supplies ms,
10362: msc_items mi,
10363: msc_items mi2,
10364: msc_trading_partners mtp,
10365: msc_gantt_query mgq
10366: where mgq.query_id = :p_query_id
10367: and mgq.node_type = :RES_NODE