APPS.WMS_ITEM_LOAD dependencies on INV_GLOBALS

Line 482: AND mtrl.line_status <> inv_globals.g_to_status_closed

478: AND mtrl.inventory_item_id = p_inventory_item_id
479: AND NVL(mtrl.revision, '###') = NVL(p_revision, '###')
480: AND NVL(mtrl.lot_number, '###') = NVL(p_lot_number, '###')
481: AND mtrl.quantity <> NVL(mtrl.quantity_delivered, 0)
482: AND mtrl.line_status <> inv_globals.g_to_status_closed
483: AND mtrl.header_id = mtrh.header_id
484: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
485: ORDER BY 2 DESC;
486: -- Variables used for matching move order lines

Line 484: AND mtrh.move_order_type = inv_globals.g_move_order_put_away

480: AND NVL(mtrl.lot_number, '###') = NVL(p_lot_number, '###')
481: AND mtrl.quantity <> NVL(mtrl.quantity_delivered, 0)
482: AND mtrl.line_status <> inv_globals.g_to_status_closed
483: AND mtrl.header_id = mtrh.header_id
484: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
485: ORDER BY 2 DESC;
486: -- Variables used for matching move order lines
487: -- when the item is serial controlled
488: l_current_serial VARCHAR2(30);

Line 507: AND mtrl.line_status <> inv_globals.g_to_status_closed

503: AND NVL(mtrl.lot_number, '###') = NVL(p_lot_number, '###')
504: AND mtrl.quantity <> NVL(mtrl.quantity_delivered, 0)
505: AND ((l_lpn_context = 3) OR
506: (l_lpn_context = 1 AND l_mo_line_count = 0))
507: AND mtrl.line_status <> inv_globals.g_to_status_closed
508: AND mtrl.header_id = mtrh.header_id
509: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
510: ORDER BY mtrl.inspection_status;
511:

Line 509: AND mtrh.move_order_type = inv_globals.g_move_order_put_away

505: AND ((l_lpn_context = 3) OR
506: (l_lpn_context = 1 AND l_mo_line_count = 0))
507: AND mtrl.line_status <> inv_globals.g_to_status_closed
508: AND mtrl.header_id = mtrh.header_id
509: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
510: ORDER BY mtrl.inspection_status;
511:
512: TYPE mol_ser_tb IS TABLE OF mol_ser_csr_for_inv_rcv%ROWTYPE;
513: l_mol_ser_tb mol_ser_tb;

Line 531: AND mtrl.line_status <> inv_globals.g_to_status_closed

527: FROM wip_lpn_completions_serials
528: WHERE l_current_serial BETWEEN fm_serial_number AND
529: to_serial_number
530: AND NVL(lot_number, '###') = NVL(p_lot_number, '###'))
531: AND mtrl.line_status <> inv_globals.g_to_status_closed
532: AND mtrl.header_id = mtrh.header_id
533: AND mtrh.move_order_type = inv_globals.g_move_order_put_away;
534:
535: -- Cursor to get the marked serials

Line 533: AND mtrh.move_order_type = inv_globals.g_move_order_put_away;

529: to_serial_number
530: AND NVL(lot_number, '###') = NVL(p_lot_number, '###'))
531: AND mtrl.line_status <> inv_globals.g_to_status_closed
532: AND mtrl.header_id = mtrh.header_id
533: AND mtrh.move_order_type = inv_globals.g_move_order_put_away;
534:
535: -- Cursor to get the marked serials
536: CURSOR marked_serials_cursor IS
537: SELECT serial_number

Line 791: AND mtrl.line_status <> inv_globals.g_to_status_closed

787: AND mtrl.inventory_item_id = p_inventory_item_id
788: AND NVL(mtrl.revision, '###') = NVL(p_revision, '###')
789: AND NVL(mtrl.lot_number, '###') = NVL(p_lot_number, '###')
790: AND mtrl.quantity <> NVL(mtrl.quantity_delivered, 0)
791: AND mtrl.line_status <> inv_globals.g_to_status_closed
792: AND mtrl.header_id = mtrh.header_id
793: AND mtrh.move_order_type = inv_globals.g_move_order_put_away;
794: IF (l_debug = 1) THEN
795: print_debug('The number of MOLs found is: ' || l_mo_line_count);

Line 793: AND mtrh.move_order_type = inv_globals.g_move_order_put_away;

789: AND NVL(mtrl.lot_number, '###') = NVL(p_lot_number, '###')
790: AND mtrl.quantity <> NVL(mtrl.quantity_delivered, 0)
791: AND mtrl.line_status <> inv_globals.g_to_status_closed
792: AND mtrl.header_id = mtrh.header_id
793: AND mtrh.move_order_type = inv_globals.g_move_order_put_away;
794: IF (l_debug = 1) THEN
795: print_debug('The number of MOLs found is: ' || l_mo_line_count);
796: END IF;
797: l_progress := '90';