APPS.ASO_UTILITY_PVT dependencies on CSI_INSTANCE_ACCTS_RG_V

Line 4270: FROM csi_instance_accts_rg_v

4266: WHERE quote_header_id = p_qte_header_id;
4267: */
4268: CURSOR c_get_orig_order_line_id(p_instance_id IN NUMBER, p_cust_account_id NUMBER) IS
4269: SELECT original_order_line_id
4270: FROM csi_instance_accts_rg_v
4271: WHERE customer_product_id = p_instance_id
4272: AND account_id = p_cust_account_id;
4273:
4274: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/

Line 4308: FROM csi_instance_accts_rg_v a ,mtl_system_items_vl b

4304: AND si.organization_id = cii.inv_master_organization_id
4305: AND cii.instance_id =p_instance_id;
4306:
4307: /* SELECT distinct a.product,b.inventory_item_id,a.quantity,a.unit_of_measure_code
4308: FROM csi_instance_accts_rg_v a ,mtl_system_items_vl b
4309: where a.product = b.concatenated_segments
4310: AND a.customer_product_id = p_instance_id;
4311: --AND a.account_id = p_cust_account_id;
4312: */

Line 4840: FROM csi_instance_accts_rg_v

4836: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4837:
4838: CURSOR c_get_orig_order_line_id(p_instance_id IN NUMBER, p_cust_account_id NUMBER) IS
4839: SELECT original_order_line_id
4840: FROM csi_instance_accts_rg_v
4841: WHERE customer_product_id = p_instance_id
4842: AND account_id = p_cust_account_id;
4843:
4844: /******* Start SUN Changes ER: 3802859 *******/