APPS.MSC_GET_GANTT_DATA dependencies on MSC_ITEMS

Line 191: msc_items msi,

187: 1,0) late_flag,
188: mrr.supply_id
189: from msc_resource_requirements mrr,
190: msc_supplies ms,
191: msc_items msi,
192: mfg_lookups mfg
193: where mrr.organization_id =v_org_id
194: and mrr.sr_instance_id = v_instance_id
195: and mrr.department_id = v_dept_id

Line 249: msc_items msi,

245: 1,0) late_flag,
246: mrr.supply_id
247: from msc_resource_requirements mrr,
248: msc_supplies ms,
249: msc_items msi,
250: mfg_lookups mfg,
251: msc_form_query mfq
252: where mrr.organization_id =v_org_id
253: and mrr.sr_instance_id = v_instance_id

Line 1971: FROM msc_items

1967: format_mask), 'null') demand_date,
1968: msc_get_name.lookup_meaning('MRP_FLP_SUPPLY_DEMAND_TYPE',
1969: v_demand_id) type,
1970: item_name item
1971: FROM msc_items
1972: WHERE inventory_item_id = v_item_id;
1973:
1974: CURSOR demand IS
1975: SELECT md.using_requirement_quantity qty,

Line 3865: msc_items mi,

3861: mtp.organization_code||':'||mi.item_name,
3862: mfq.number14,
3863: mfq.number15
3864: from msc_form_query mfq,
3865: msc_items mi,
3866: msc_trading_partners mtp
3867: where mfq.query_id = p_query_id
3868: and mfq.number1 = p_supply_id
3869: and mfq.number2 =p_op_seq_num

Line 5737: msc_items mi,

5733: to_char(md.using_assembly_demand_date,format_mask),
5734: to_char(nvl(md.dmd_satisfied_date,md.using_assembly_demand_date),format_mask),
5735: demand_priority
5736: from msc_demands md,
5737: msc_items mi,
5738: msc_trading_partners mtp
5739: where md.demand_id = p_demand_id
5740: and md.plan_id = p_plan_id
5741: and mi.inventory_item_id = md.inventory_item_id