DBA Data[Home] [Help]

APPS.MSC_DEMAND_PKG dependencies on MSC_SYSTEM_ITEMS

Line 130: msc_system_items msi

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

Line 702: from msc_system_items msi_1,

698: msi_1.standard_cost,
699: msi_1.list_price,
700: msi_1.AVERAGE_DISCOUNT,
701: nvl(f_1.number10,0) vmi_flag
702: from msc_system_items msi_1,
703: msc_hub_query f_1
704: where f_1.query_id(+) = l_qid_vmi
705: and f_1.number1(+) = msi_1.plan_id
706: and f_1.number3(+) = msi_1.sr_instance_id

Line 873: from msc_system_items msi_2,

869: msi_2.standard_cost,
870: msi_2.list_price,
871: msi_2.AVERAGE_DISCOUNT,
872: nvl(f_2.number10,0) vmi_flag
873: from msc_system_items msi_2,
874: msc_hub_query f_2
875: where f_2.query_id(+) = l_qid_vmi
876: and f_2.number1(+) = msi_2.plan_id
877: and f_2.number3(+) = msi_2.sr_instance_id