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 1110: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

1106: , mtrl.txn_source_id
1107: , mtrl.txn_source_line_id
1108: , mtrl.txn_source_line_detail_id
1109: , mtrl.transaction_type_id
1110: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
1111: WHERE mtrl.lpn_id = p_lpn_id
1112: AND mtrl.organization_id = p_org_id
1113: AND mtrl.header_id = mtrh.header_id
1114: AND mtrl.line_status <> inv_globals.g_to_status_closed

Line 1135: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

1131: , mtrl.txn_source_line_id
1132: , mtrl.txn_source_line_detail_id
1133: , mtrl.transaction_type_id
1134:
1135: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
1136: WHERE mtrl.lpn_id = p_lpn_id
1137: AND mtrl.organization_id = p_org_id
1138: AND mtrl.header_id = mtrh.header_id
1139: AND mtrl.line_status <> inv_globals.g_to_status_closed

Line 1357: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

1353: INTO l_rcount
1354: FROM DUAL
1355: WHERE EXISTS(
1356: SELECT 1
1357: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
1358: WHERE l.lpn_id = l_lpn_id
1359: AND l.line_id = NVL(p_move_order_line_id, l.line_id) -- added for ATF_J
1360: AND NVL(l.quantity_delivered, 0) < l.quantity -- added for ATF_J
1361: AND l.organization_id = p_org_id

Line 1490: FROM mtl_txn_request_headers moh

1486: AND mol.organization_id = p_org_id
1487: AND mol.quantity_detailed > 0
1488: AND EXISTS(
1489: SELECT 1
1490: FROM mtl_txn_request_headers moh
1491: WHERE mol.header_id = moh.header_id
1492: AND moh.move_order_type = inv_globals.g_move_order_put_away)));
1493:
1494: -- ATF_J2

Line 1513: FROM mtl_txn_request_headers moh

1509: AND mol.organization_id = p_org_id
1510: AND mol.quantity_detailed > 0
1511: AND EXISTS(
1512: SELECT 1
1513: FROM mtl_txn_request_headers moh
1514: WHERE mol.header_id = moh.header_id
1515: AND moh.move_order_type = inv_globals.g_move_order_put_away)));
1516:
1517: DELETE FROM mtl_material_transactions_temp

Line 1526: FROM mtl_txn_request_headers moh

1522: AND mol.line_id = NVL(p_move_order_line_id, mol.line_id) -- added for ATF_J
1523: AND mol.organization_id = p_org_id
1524: AND mol.quantity_detailed > 0
1525: AND EXISTS(SELECT 1
1526: FROM mtl_txn_request_headers moh
1527: WHERE mol.header_id = moh.header_id
1528: AND moh.move_order_type = inv_globals.g_move_order_put_away));
1529:
1530: UPDATE mtl_txn_request_lines mol

Line 1537: FROM mtl_txn_request_headers moh

1533: AND mol.line_id = NVL(p_move_order_line_id, mol.line_id) -- added for ATF_J
1534: AND mol.organization_id = p_org_id
1535: -- AND mol.quantity_detailed > 0 -- removed in ATF_J3
1536: AND EXISTS(SELECT 1
1537: FROM mtl_txn_request_headers moh
1538: WHERE mol.header_id = moh.header_id
1539: AND moh.move_order_type = inv_globals.g_move_order_put_away);
1540:
1541: IF (l_debug = 1) THEN

Line 7681: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol

7677: -- Cursor added to retrieve valid MO header IDs so we can avoid
7678: -- the hash join problem.
7679: CURSOR c_header_id IS
7680: SELECT moh.header_id
7681: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol
7682: WHERE moh.move_order_type = inv_globals.g_move_order_put_away
7683: AND moh.header_id = mol.header_id
7684: AND mol.lpn_id = p_lpn_id;
7685: l_header_id NUMBER;

Line 7813: mtl_txn_request_headers moh,

7809: AND mol.quantity_detailed > 0
7810: AND EXISTS
7811: (SELECT 1
7812: FROM
7813: mtl_txn_request_headers moh,
7814: wms_license_plate_numbers wlc
7815: WHERE mol.header_id = moh.header_id
7816: AND moh.move_order_type = inv_globals.g_move_order_put_away
7817: AND wlc.lpn_id = mol.lpn_id

Line 8455: FROM mtl_txn_request_headers moh

8451: , mol.SECONDARY_UOM_CODE --BUG12796808
8452: FROM mtl_txn_request_lines mol
8453: WHERE mol.organization_id = p_organization_id
8454: AND mol.header_id IN (SELECT moh.header_id
8455: FROM mtl_txn_request_headers moh
8456: WHERE moh.move_order_type = inv_globals.g_move_order_put_away
8457: )
8458: AND mol.line_status = 7
8459: AND mol.lpn_id = l_current_lpn_id;