DBA Data[Home] [Help]

APPS.MSC_PEG_UTIL dependencies on MSC_SUPPLIES

Line 81: msc_supplies ms

77: x_itemorg_pegnode_rec.Item_id,
78: x_itemorg_pegnode_rec.Order_type,
79: x_itemorg_pegnode_rec.Disposition
80: from msc_items mis,
81: msc_supplies ms
82: where mis.inventory_item_id = ms.inventory_item_id
83: and ms.transaction_id = l_disposition_id
84: and ms.plan_id = p_plan_id
85: and ms.organization_id = p_organization_id

Line 191: from msc_supplies

187:
188: -- Sometimes after button Supply Pegging is clicked pld is not sending item_id
189: cursor inventory_item_id IS
190: select inventory_item_id
191: from msc_supplies
192: where transaction_id = p_transaction_id
193: and plan_id = p_plan_id
194: and sr_instance_id = p_instance_id
195: and organization_id = p_organization_id;