783: null,
784: null))
785: from mtl_txn_request_lines mtrl,
786: csp_sec_inventories csi,
787: mtl_system_items_b msib,
788: csp_planning_parameters cpp
789: where mtrl.organization_id = csi.organization_id
790: and mtrl.organization_id = msib.organization_id
791: and mtrl.inventory_item_id = msib.inventory_item_id
823: msib.primary_uom_code,
824: null,
825: null))
826: from mtl_txn_request_lines mtrl,
827: mtl_system_items_b msib,
828: csp_planning_parameters cpp
829: where mtrl.to_organization_id = cpp.organization_id
830: and mtrl.to_subinventory_code = cpp.secondary_inventory
831: and mtrl.line_status in (3,7)
866: null,
867: null))
868: from mtl_txn_request_lines mtrl,
869: csp_sec_inventories csi,
870: mtl_system_items_b msib,
871: csp_planning_parameters cpp
872: where mtrl.organization_id = csi.organization_id
873: and mtrl.organization_id = msib.organization_id
874: and mtrl.inventory_item_id = msib.inventory_item_id
908: msib.primary_uom_code,
909: null,
910: null))
911: from mtl_txn_request_lines mtrl,
912: mtl_system_items_b msib,
913: csp_planning_parameters cpp
914: where mtrl.organization_id = cpp.organization_id
915: and mtrl.organization_id = msib.organization_id
916: and mtrl.inventory_item_id = msib.inventory_item_id
952: msib.primary_uom_code,
953: null,
954: null))
955: from mtl_txn_request_lines mtrl,
956: mtl_system_items_b msib,
957: csp_planning_parameters cpp
958: where mtrl.organization_id = cpp.organization_id
959: and mtrl.organization_id = msib.organization_id
960: and mtrl.inventory_item_id = msib.inventory_item_id
995: msib.primary_uom_code,
996: null,
997: null))
998: from mtl_txn_request_lines mtrl,
999: mtl_system_items_b msib,
1000: csp_planning_parameters cpp
1001: where mtrl.organization_id = cpp.organization_id
1002: and mtrl.organization_id = msib.organization_id
1003: and mtrl.inventory_item_id = msib.inventory_item_id