DBA Data[Home] [Help]

APPS.ASO_PRICING_FLOWS_PVT dependencies on CSI_INSTANCE_ACCTS_RG_V

Line 772: FROM csi_instance_accts_rg_v

768:
769:
770: CURSOR c_csi_line(p_instance_id IN NUMBER, p_cust_account_id NUMBER) IS
771: SELECT original_order_line_id
772: FROM csi_instance_accts_rg_v
773: WHERE customer_product_id = p_instance_id
774: AND account_id = p_cust_account_id;
775:
776:

Line 791: FROM csi_instance_accts_rg_v a ,mtl_system_items_vl b

787: AND si.organization_id = cii.inv_master_organization_id
788: AND cii.instance_id =p_instance_id;
789:
790: /* SELECT distinct a.product,b.inventory_item_id,a.quantity,a.unit_of_measure_code
791: FROM csi_instance_accts_rg_v a ,mtl_system_items_vl b
792: where a.product = b.concatenated_segments
793: AND a.customer_product_id = p_instance_id;
794: --AND a.account_id = p_cust_account_id;
795: */