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_TASK_DISPATCH_PUT_AWAY dependencies on MTL_TXN_REQUEST_HEADERS

Line 979: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

975: , NVL(crossdock_type, 1)
976: , mtrl.to_subinventory_code
977: , mtrl.to_locator_id
978: , mtrl.reference_detail_id
979: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
980: WHERE mtrl.lpn_id = p_lpn_id
981: AND mtrl.organization_id = p_org_id
982: AND mtrl.header_id = mtrh.header_id
983: AND mtrl.line_status <> inv_globals.g_to_status_closed

Line 999: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

995: , NVL(crossdock_type, 1)
996: , mtrl.to_subinventory_code
997: , mtrl.to_locator_id
998: , mtrl.reference_detail_id
999: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
1000: WHERE mtrl.lpn_id = p_lpn_id
1001: AND mtrl.organization_id = p_org_id
1002: AND mtrl.header_id = mtrh.header_id
1003: AND mtrl.line_status <> inv_globals.g_to_status_closed

Line 1212: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

1208: INTO l_rcount
1209: FROM DUAL
1210: WHERE EXISTS(
1211: SELECT 1
1212: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
1213: WHERE l.lpn_id = l_lpn_id
1214: AND l.line_id = NVL(p_move_order_line_id, l.line_id) -- added for ATF_J
1215: AND NVL(l.quantity_delivered, 0) < l.quantity -- added for ATF_J
1216: AND l.organization_id = p_org_id

Line 1345: FROM mtl_txn_request_headers moh

1341: AND mol.organization_id = p_org_id
1342: AND mol.quantity_detailed > 0
1343: AND EXISTS(
1344: SELECT 1
1345: FROM mtl_txn_request_headers moh
1346: WHERE mol.header_id = moh.header_id
1347: AND moh.move_order_type = inv_globals.g_move_order_put_away)));
1348:
1349: -- ATF_J2

Line 1368: FROM mtl_txn_request_headers moh

1364: AND mol.organization_id = p_org_id
1365: AND mol.quantity_detailed > 0
1366: AND EXISTS(
1367: SELECT 1
1368: FROM mtl_txn_request_headers moh
1369: WHERE mol.header_id = moh.header_id
1370: AND moh.move_order_type = inv_globals.g_move_order_put_away)));
1371:
1372: DELETE FROM mtl_material_transactions_temp

Line 1381: FROM mtl_txn_request_headers moh

1377: AND mol.line_id = NVL(p_move_order_line_id, mol.line_id) -- added for ATF_J
1378: AND mol.organization_id = p_org_id
1379: AND mol.quantity_detailed > 0
1380: AND EXISTS(SELECT 1
1381: FROM mtl_txn_request_headers moh
1382: WHERE mol.header_id = moh.header_id
1383: AND moh.move_order_type = inv_globals.g_move_order_put_away));
1384:
1385: UPDATE mtl_txn_request_lines mol

Line 1392: FROM mtl_txn_request_headers moh

1388: AND mol.line_id = NVL(p_move_order_line_id, mol.line_id) -- added for ATF_J
1389: AND mol.organization_id = p_org_id
1390: -- AND mol.quantity_detailed > 0 -- removed in ATF_J3
1391: AND EXISTS(SELECT 1
1392: FROM mtl_txn_request_headers moh
1393: WHERE mol.header_id = moh.header_id
1394: AND moh.move_order_type = inv_globals.g_move_order_put_away);
1395:
1396: IF (l_debug = 1) THEN

Line 7354: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol

7350: -- Cursor added to retrieve valid MO header IDs so we can avoid
7351: -- the hash join problem.
7352: CURSOR c_header_id IS
7353: SELECT moh.header_id
7354: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol
7355: WHERE moh.move_order_type = inv_globals.g_move_order_put_away
7356: AND moh.header_id = mol.header_id
7357: AND mol.lpn_id = p_lpn_id;
7358: l_header_id NUMBER;

Line 7480: mtl_txn_request_headers moh,

7476: AND mol.quantity_detailed > 0
7477: AND EXISTS
7478: (SELECT 1
7479: FROM
7480: mtl_txn_request_headers moh,
7481: wms_license_plate_numbers wlc
7482: WHERE mol.header_id = moh.header_id
7483: AND moh.move_order_type = inv_globals.g_move_order_put_away
7484: AND wlc.lpn_id = mol.lpn_id

Line 8114: FROM mtl_txn_request_headers moh

8110: , mol.to_cost_group_id
8111: FROM mtl_txn_request_lines mol
8112: WHERE mol.organization_id = p_organization_id
8113: AND mol.header_id IN (SELECT moh.header_id
8114: FROM mtl_txn_request_headers moh
8115: WHERE moh.move_order_type = inv_globals.g_move_order_put_away
8116: )
8117: AND mol.line_status = 7
8118: AND mol.lpn_id = l_current_lpn_id;