eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_ITEM_LOAD dependencies on MTL_TXN_REQUEST_LINES

Line 475: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

471: mtrl.uom_code,
472: --laks
473: mtrl.secondary_quantity - NVL(mtrl.secondary_quantity_delivered, 0),
474: mtrl.secondary_uom_code
475: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
476: WHERE mtrl.organization_id = p_organization_id
477: AND mtrl.lpn_id = p_lpn_id
478: AND mtrl.inventory_item_id = p_inventory_item_id
479: AND NVL(mtrl.revision, '###') = NVL(p_revision, '###')

Line 498: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

494: CURSOR mol_ser_csr_for_inv_rcv IS
495: SELECT mtrl.line_id
496: , Nvl(mtrl.inspection_status,0) inspection_status
497: , quantity-Nvl(quantity_delivered,0) avail_qty
498: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
499: WHERE mtrl.organization_id = p_organization_id
500: AND mtrl.lpn_id = p_lpn_id
501: AND mtrl.inventory_item_id = p_inventory_item_id
502: AND NVL(mtrl.revision, '###') = NVL(p_revision, '###')

Line 518: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

514:
515: -- Cursor to get the move order lines for WIP serials
516: CURSOR mol_ser_csr_for_wip IS
517: SELECT mtrl.line_id
518: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
519: WHERE mtrl.organization_id = p_organization_id
520: AND mtrl.lpn_id = p_lpn_id
521: AND mtrl.inventory_item_id = p_inventory_item_id
522: AND NVL(mtrl.revision, '###') = NVL(p_revision, '###')

Line 600: FROM mtl_txn_request_lines

596: FROM wip_lpn_completions_serials wlcs, mtl_serial_numbers msn
597: WHERE l_lpn_context = 2
598: AND NVL(wlcs.lot_number, '###') = NVL(p_lot_number, '###')
599: AND wlcs.header_id IN (SELECT reference_id
600: FROM mtl_txn_request_lines
601: WHERE line_id = l_mo_line_id
602: AND organization_id = p_organization_id)
603: AND wlcs.fm_serial_number = msn.serial_number
604: AND msn.inventory_item_id = p_inventory_item_id

Line 784: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

780:
781: -- Check if any valid move order lines exist for the item load entry
782: SELECT COUNT(*)
783: INTO l_mo_line_count
784: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
785: WHERE mtrl.organization_id = p_organization_id
786: AND mtrl.lpn_id = p_lpn_id
787: AND mtrl.inventory_item_id = p_inventory_item_id
788: AND NVL(mtrl.revision, '###') = NVL(p_revision, '###')

Line 1590: FROM mtl_txn_request_lines

1586: , to_locator_id
1587: INTO l_backorder_delivery_detail_id
1588: , l_to_sub_code
1589: , l_to_loc_id
1590: FROM mtl_txn_request_lines
1591: WHERE line_id = l_tmp_mo_lines_tb(l_index).line_id;
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: IF (l_debug = 1) THEN

Line 1636: FROM mtl_txn_request_lines

1632: END IF;
1633:
1634: FOR l_splitted_rec IN (SELECT line_id
1635: , primary_quantity
1636: FROM mtl_txn_request_lines
1637: WHERE reference_detail_id = l_tmp_mo_lines_tb(l_index).line_id) LOOP
1638:
1639: IF (l_debug = 1) THEN
1640: print_debug('Splitted Line:'||l_splitted_rec.line_id);

Line 1650: UPDATE mtl_txn_request_lines

1646: l_mo_lines_tb(l_tmp_index).prim_qty := l_splitted_rec.primary_quantity;
1647: l_mo_lines_tb(l_index).prim_qty := l_mo_lines_tb(l_index).prim_qty - l_splitted_rec.primary_quantity;
1648:
1649: BEGIN
1650: UPDATE mtl_txn_request_lines
1651: SET reference_detail_id = NULL
1652: WHERE line_id = l_splitted_rec.line_id;
1653: EXCEPTION
1654: WHEN OTHERS THEN

Line 1693: UPDATE mtl_txn_request_lines

1689: IF (l_debug = 1) THEN
1690: print_debug('Receiving LPN so update wms_process_flag on the MOL');
1691: END IF;
1692: BEGIN
1693: UPDATE mtl_txn_request_lines
1694: SET wms_process_flag = 2
1695: WHERE line_id = l_mo_lines_tb(l_index).line_id
1696: AND organization_id = p_organization_id;
1697: EXCEPTION

Line 1793: FROM mtl_txn_request_lines

1789:
1790: -- Now get some additional info from the move order line
1791: SELECT NVL(txn_source_id, -999), NVL(project_id, -999), NVL(task_id, -999)
1792: INTO l_txn_src_id, l_project_id, l_task_id
1793: FROM mtl_txn_request_lines
1794: WHERE organization_id = p_organization_id
1795: AND line_id = l_mo_lines_tb(l_index).line_id;
1796: l_progress := '420';
1797:

Line 2323: FROM mtl_txn_request_lines

2319: IF (p_lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_INV) THEN
2320: SELECT NVL(transaction_source_type_id, -999),
2321: NVL(transaction_type_id, -999)
2322: INTO l_txn_source_type_id, l_txn_type_id
2323: FROM mtl_txn_request_lines
2324: WHERE line_id = l_mo_line_id;
2325: IF (l_debug = 1) THEN
2326: print_debug('Move Order Line values');
2327: print_debug('Txn Source Type ID: => ' || l_txn_source_type_id);

Line 3081: UPDATE mtl_txn_request_lines

3077: IF (l_debug = 1) THEN
3078: print_debug('Update the LPN ID/SUB/LOC on MOL record');
3079: END IF;
3080: BEGIN
3081: UPDATE mtl_txn_request_lines
3082: SET lpn_id = p_into_lpn_id
3083: , from_subinventory_code = Decode(p_lpn_context,
3084: WMS_CONTAINER_PUB.lpn_context_inv,
3085: l_into_sub,

Line 3526: mtl_txn_request_lines mtrl,

3522: -- Cleanup should not be called if there are no WDT records.
3523: CURSOR mmtt_suggestions_cursor IS
3524: SELECT mmtt.transaction_temp_id
3525: FROM mtl_material_transactions_temp mmtt,
3526: mtl_txn_request_lines mtrl,
3527: wms_dispatched_tasks wdt
3528: WHERE mmtt.organization_id = p_organization_id
3529: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
3530: AND wdt.task_type = 2