DBA Data[Home] [Help]

APPS.MSC_PQ_UTILS dependencies on MSC_ORDERS_V

Line 85: FROM msc_orders_v

81: p_inventory_item_id IN NUMBER,
82: p_from_date IN DATE,
83: p_to_date IN DATE ) IS
84: SELECT transaction_id
85: FROM msc_orders_v
86: WHERE plan_id = p_plan_id
87: AND sr_instance_id = p_instance_id
88: AND organization_id = p_organization_id
89: AND inventory_item_id = p_inventory_item_id

Line 2197: FROM msc_orders_v

2193: AND pq.query_type = 9;
2194:
2195: CURSOR cur_orders(p_transaction_Id IN NUMBER) IS
2196: SELECT sr_instance_id,organization_id, organization_code
2197: FROM msc_orders_v
2198: WHERE plan_id = p_plan_Id
2199: AND p_transaction_Id = p_transaction_Id;
2200: -- and
2201: