DBA Data[Home] [Help]

APPS.ASO_PRICING_FLOWS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 784: FROM mtl_system_items_kfv si, csi_item_instances cii

780:
781: -- changed cursor for bug 12839557
782: CURSOR c_csi_line_details(p_instance_id IN NUMBER, p_cust_account_id NUMBER) IS
783: SELECT si.concatenated_segments product, si.inventory_item_id, cii.quantity, cii.unit_of_measure
784: FROM mtl_system_items_kfv si, csi_item_instances cii
785: WHERE NVL(cii.active_end_date, (SYSDATE + 1)) > SYSDATE
786: AND cii.inventory_item_id = si.inventory_item_id
787: AND si.organization_id = cii.inv_master_organization_id
788: AND cii.instance_id =p_instance_id;