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