APPS.WMS_WIP_XDOCK_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 100: FROM wip_material_shortages_v w, mtl_txn_request_lines l

96: , w.operation_seq_num
97: , w.wip_issue_flag
98: , w.subinventory_code
99: , w.locator_id
100: FROM wip_material_shortages_v w, mtl_txn_request_lines l
101: WHERE l.lpn_id = l_lpn_id
102: AND l.line_id = NVL(p_move_order_line_id, l.line_id) -- added for ATF_J
103: AND l.organization_id = l_org_id
104: AND w.organization_id = l_org_id

Line 143: FROM wip_material_shortages_v b, mtl_txn_request_lines l

139: INTO l_count
140: FROM DUAL
141: WHERE EXISTS(
142: SELECT 1
143: FROM wip_material_shortages_v b, mtl_txn_request_lines l
144: WHERE l.lpn_id = l_lpn_id
145: AND l.line_id = NVL(p_move_order_line_id, l.line_id) -- added for ATF_J
146: AND l.organization_id = l_org_id
147: AND b.organization_id = l.organization_id

Line 170: FROM mtl_txn_request_lines

166: INTO l_insp_cnt
167: FROM DUAL
168: WHERE EXISTS(
169: SELECT 1
170: FROM mtl_txn_request_lines
171: WHERE lpn_id = l_lpn_id
172: AND line_id = NVL(p_move_order_line_id, line_id) -- added for ATF_J
173: AND organization_id = l_org_id
174: AND NVL(inspection_status, 2) = 3);

Line 316: FROM mtl_txn_request_lines mol, mtl_system_items msi

312: , l_loc
313: , l_inspection_status
314: , l_line_id
315: , l_primary_uom
316: FROM mtl_txn_request_lines mol, mtl_system_items msi
317: WHERE lpn_id = l_lpn_id
318: AND line_id = NVL(p_move_order_line_id, line_id) -- added for ATF_J
319: AND mol.organization_id = l_org_id
320: AND mol.inventory_item_id = l_wip_item

Line 398: --UPDATE mtl_txn_request_lines SET

394: mydebug('MOL>WIP');
395: END IF;
396:
397: -- update mol with new qty
398: --UPDATE mtl_txn_request_lines SET
399: --quantity=l_wip_qty,BACKORDER_DELIVERY_DETAIL_ID=l_wip_id
400: --,to_subinventory_code=l_to_sub,to_locator_id=l_to_loc, crossdock_type=2
401: --WHERE line_id=l_line_id;
402:

Line 454: UPDATE mtl_txn_request_lines

450: IF (l_debug = 1) THEN
451: mydebug('Updating the old mo line');
452: END IF;
453:
454: UPDATE mtl_txn_request_lines
455: SET quantity = l_quantity_allocated
456: , backorder_delivery_detail_id = l_wip_id
457: , to_subinventory_code = l_to_sub
458: , to_locator_id = l_to_loc

Line 525: --UPDATE mtl_txn_request_lines SET

521: END IF;
522:
523: -- update mol with new qty
524: -- Try to get next mol
525: --UPDATE mtl_txn_request_lines SET
526: -- BACKORDER_DELIVERY_DETAIL_ID=l_wip_id
527: -- ,to_subinventory_code=l_to_sub,to_locator_id=l_to_loc, crossdock_type=2
528: --WHERE line_id=l_line_id;
529: -- Call update shipping API with back order action

Line 584: UPDATE mtl_txn_request_lines

580: IF (l_debug = 1) THEN
581: mydebug('updating the old mol');
582: END IF;
583:
584: UPDATE mtl_txn_request_lines
585: SET backorder_delivery_detail_id = l_wip_id
586: , quantity = l_quantity_allocated
587: , to_subinventory_code = l_to_sub
588: , to_locator_id = l_to_loc

Line 656: UPDATE mtl_txn_request_lines

652: mydebug(' qty allocated is same as lpn_qty ');
653: mydebug(' update old mol ');
654: END IF;
655:
656: UPDATE mtl_txn_request_lines
657: SET backorder_delivery_detail_id = l_wip_id
658: , to_subinventory_code = l_to_sub
659: , to_locator_id = l_to_loc
660: , crossdock_type = 2

Line 739: UPDATE mtl_txn_request_lines

735: mydebug('l_lpn_qty > l_quantity_allocated ');
736: mydebug('updating the old mol ');
737: END IF;
738:
739: UPDATE mtl_txn_request_lines
740: SET backorder_delivery_detail_id = l_wip_id
741: , quantity = l_quantity_allocated
742: , to_subinventory_code = l_to_sub
743: , to_locator_id = l_to_loc

Line 811: UPDATE mtl_txn_request_lines

807: mydebug('qty allocated equals lpn_qty ');
808: mydebug('updating the old mol ');
809: END IF;
810:
811: UPDATE mtl_txn_request_lines
812: SET backorder_delivery_detail_id = l_wip_id
813: , to_subinventory_code = l_to_sub
814: , to_locator_id = l_to_loc
815: , crossdock_type = 2