DBA Data[Home] [Help]

APPS.MSC_ITEM_PKG dependencies on MSC_SYSTEM_ITEMS

Line 131: msc_system_items msi

127: msi.organization_id,
128: msi.inventory_item_id,
129: nvl(mis.vmi_flag,0)
130: from msc_item_suppliers mis,
131: msc_system_items msi
132: where msi.plan_id = mis.plan_id
133: and msi.sr_instance_id = mis.sr_instance_id
134: and msi.organization_id = mis.organization_id
135: and msi.inventory_item_id = mis.inventory_item_id

Line 882: msc_system_items msi

878: mfq1.number7,
879: mfq1.number8,
880: mfq1.date3
881: ) d,
882: msc_system_items msi
883: where d.plan_id = s.plan_id
884: and d.plan_run_id = s.plan_run_id
885: and d.sr_instance_id = s.sr_instance_id
886: and d.organization_id = s.organization_id

Line 1236: msc_system_items m1,

1232: ORDER by p.date3) pab_qty
1233: from msc_hub_query l,msc_hub_query p
1234: where l.query_id =l_qid_last_date and p.query_id=l_qid_pab
1235: and l.date3 = p.date3) pab,
1236: msc_system_items m1,
1237: msc_trading_partners mtp,
1238: msc_plans mp --- bug
1239: where pab.plan_id = m1.plan_id(+)
1240: and pab.sr_instance_id = m1.sr_instance_id(+)

Line 1354: msc_system_items mil_msi,

1350: item.date1 order_date, -- move to bkt start date,may not a working day
1351: nvl(mil.MIN_QUANTITY,mil_msi.MIN_MINMAX_QUANTITY) min_inventory_level,
1352: nvl(mil.max_quantity, mil_msi.MAX_MINMAX_QUANTITY) max_inventory_level
1353: from msc_inventory_levels mil,
1354: msc_system_items mil_msi,
1355: msc_hub_query item
1356: where item.query_id = l_qid_mil_item
1357: and item.number1 = mil.plan_id(+)
1358: and item.number3 = mil.sr_instance_id(+)

Line 1564: from msc_system_items msi_1,

1560: msi_1.organization_id,
1561: msi_1.inventory_item_id,
1562: msi_1.standard_cost,
1563: nvl(vmi.number6,0) vmi_flag
1564: from msc_system_items msi_1,
1565: msc_hub_query vmi
1566: where vmi.query_id(+) =l_qid_vmi_item
1567: and vmi.number1(+) = msi_1.plan_id
1568: and vmi.number3(+) = msi_1.sr_instance_id