DBA Data[Home] [Help]

APPS.MSC_PQ_UTILS dependencies on MSC_ORDERS_V

Line 89: FROM msc_orders_v

85: p_inventory_item_id IN NUMBER,
86: p_from_date IN DATE,
87: p_to_date IN DATE ) IS
88: SELECT transaction_id
89: FROM msc_orders_v
90: WHERE plan_id = p_plan_id
91: AND sr_instance_id = p_instance_id
92: AND organization_id = p_organization_id
93: AND inventory_item_id = p_inventory_item_id

Line 2247: FROM msc_orders_v

2243: --AND pq.query_type = 9;
2244:
2245: CURSOR cur_orders(p_transaction_Id IN NUMBER) IS
2246: SELECT sr_instance_id,organization_id, organization_code
2247: FROM msc_orders_v
2248: WHERE plan_id = p_plan_Id
2249: AND p_transaction_Id = p_transaction_Id;
2250: -- and
2251: