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 INV_GLOBALS

Line 278: l_trolin_tbl(l_order_count).line_status := inv_globals.g_to_status_preapproved;

274: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
275: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;
276: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;
277: l_trolin_tbl(l_order_count).line_number := l_line_num;
278: l_trolin_tbl(l_order_count).line_status := inv_globals.g_to_status_preapproved;
279: l_trolin_tbl(l_order_count).organization_id := p_org_id;
280: l_trolin_tbl(l_order_count).quantity := p_qty;
281: l_trolin_tbl(l_order_count).status_date := SYSDATE;
282: l_trolin_tbl(l_order_count).to_subinventory_code := NULL;

Line 285: l_trolin_tbl(l_order_count).operation := inv_globals.g_opr_create;

281: l_trolin_tbl(l_order_count).status_date := SYSDATE;
282: l_trolin_tbl(l_order_count).to_subinventory_code := NULL;
283: l_trolin_tbl(l_order_count).uom_code := p_uom;
284: l_trolin_tbl(l_order_count).db_flag := fnd_api.g_true;
285: l_trolin_tbl(l_order_count).operation := inv_globals.g_opr_create;
286: l_trolin_tbl(l_order_count).lpn_id := p_lpn;
287: l_trolin_tbl(l_order_count).REFERENCE := l_ref;
288: l_trolin_tbl(l_order_count).reference_type_code := l_ref_type;
289: l_trolin_tbl(l_order_count).reference_id := l_ref_id;

Line 551: AND line_status <> inv_globals.g_to_status_closed

547: SELECT 1
548: FROM mtl_txn_request_lines
549: WHERE lpn_id = p_lpn
550: AND organization_id = p_org_id
551: AND line_status <> inv_globals.g_to_status_closed
552: AND NVL(project_id, -1) <> NVL(p_project_id, -1)
553: AND NVL(task_id, -1) <> NVL(p_task_id, -1));
554:
555: fnd_message.set_name('WMS', 'WMS_PROJ_LPN_COMINGLE');

Line 602: l_trohdr_rec.header_status := inv_globals.g_to_status_preapproved;

598: l_trohdr_rec.created_by := fnd_global.user_id;
599: l_trohdr_rec.creation_date := SYSDATE;
600: l_trohdr_rec.date_required := SYSDATE;
601: l_trohdr_rec.from_subinventory_code := p_sub;
602: l_trohdr_rec.header_status := inv_globals.g_to_status_preapproved;
603: l_trohdr_rec.last_updated_by := fnd_global.user_id;
604: l_trohdr_rec.last_update_date := SYSDATE;
605: l_trohdr_rec.last_update_login := fnd_global.user_id;
606: l_trohdr_rec.organization_id := l_org_id;

Line 609: l_trohdr_rec.move_order_type := inv_globals.g_move_order_put_away;

605: l_trohdr_rec.last_update_login := fnd_global.user_id;
606: l_trohdr_rec.organization_id := l_org_id;
607: l_trohdr_rec.status_date := SYSDATE;
608: l_trohdr_rec.to_subinventory_code := NULL;
609: l_trohdr_rec.move_order_type := inv_globals.g_move_order_put_away;
610: l_trohdr_rec.db_flag := fnd_api.g_true;
611: l_trohdr_rec.operation := inv_globals.g_opr_create;
612: l_line_num := l_line_num + 1;
613: l_trolin_tbl(l_order_count).header_id := l_trohdr_rec.header_id;

Line 611: l_trohdr_rec.operation := inv_globals.g_opr_create;

607: l_trohdr_rec.status_date := SYSDATE;
608: l_trohdr_rec.to_subinventory_code := NULL;
609: l_trohdr_rec.move_order_type := inv_globals.g_move_order_put_away;
610: l_trohdr_rec.db_flag := fnd_api.g_true;
611: l_trohdr_rec.operation := inv_globals.g_opr_create;
612: l_line_num := l_line_num + 1;
613: l_trolin_tbl(l_order_count).header_id := l_trohdr_rec.header_id;
614: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;
615: l_trolin_tbl(l_order_count).creation_date := SYSDATE;

Line 627: l_trolin_tbl(l_order_count).line_status := inv_globals.g_to_status_preapproved;

623: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
624: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;
625: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;
626: l_trolin_tbl(l_order_count).line_number := l_line_num;
627: l_trolin_tbl(l_order_count).line_status := inv_globals.g_to_status_preapproved;
628: l_trolin_tbl(l_order_count).organization_id := l_org_id;
629: l_trolin_tbl(l_order_count).quantity := l_qty;
630: l_trolin_tbl(l_order_count).status_date := SYSDATE;
631: l_trolin_tbl(l_order_count).to_subinventory_code := NULL;

Line 634: l_trolin_tbl(l_order_count).operation := inv_globals.g_opr_create;

630: l_trolin_tbl(l_order_count).status_date := SYSDATE;
631: l_trolin_tbl(l_order_count).to_subinventory_code := NULL;
632: l_trolin_tbl(l_order_count).uom_code := l_uom;
633: l_trolin_tbl(l_order_count).db_flag := fnd_api.g_true;
634: l_trolin_tbl(l_order_count).operation := inv_globals.g_opr_create;
635: l_trolin_tbl(l_order_count).lpn_id := p_lpn;
636: l_trolin_tbl(l_order_count).REFERENCE := l_ref;
637: l_trolin_tbl(l_order_count).reference_type_code := l_ref_type;
638: l_trolin_tbl(l_order_count).reference_id := l_ref_id;

Line 653: -- l_trolin_tbl(l_order_count).move_order_type:=inv_globals.g_move_order_put_away;

649:
650: l_trolin_tbl(l_order_count).secondary_quantity := l_sec_qty; -- Added for OPM convergance
651: l_trolin_tbl(l_order_count).secondary_uom := l_sec_uom; -- Added for OPM convergance
652:
653: -- l_trolin_tbl(l_order_count).move_order_type:=inv_globals.g_move_order_put_away;
654: IF (p_txn_source_id <> fnd_api.g_miss_num) THEN
655: l_trolin_tbl(l_order_count).txn_source_id := l_txn_source_id;
656: END IF;
657:

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

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
984: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
985: AND mtrl.line_id = NVL(p_move_order_line_id, mtrl.line_id) -- added for ATF_J
986:
987: --BUG 5194761

Line 984: AND mtrh.move_order_type = inv_globals.g_move_order_put_away

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
984: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
985: AND mtrl.line_id = NVL(p_move_order_line_id, mtrl.line_id) -- added for ATF_J
986:
987: --BUG 5194761
988: UNION

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

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
1004: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
1005: AND p_move_order_line_id IS NOT NULL
1006: AND mtrl.reference_detail_id = p_move_order_line_id;
1007: --END BUG 5194761

Line 1004: AND mtrh.move_order_type = inv_globals.g_move_order_put_away

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
1004: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
1005: AND p_move_order_line_id IS NOT NULL
1006: AND mtrl.reference_detail_id = p_move_order_line_id;
1007: --END BUG 5194761
1008:

Line 1218: AND l.line_status <> inv_globals.g_to_status_closed

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
1217: AND l.header_id = h.header_id
1218: AND l.line_status <> inv_globals.g_to_status_closed
1219: AND h.move_order_type = inv_globals.g_move_order_put_away);
1220: -- AND Nvl(l.quantity_detailed,0) 1221:
1222: EXCEPTION

Line 1219: AND h.move_order_type = inv_globals.g_move_order_put_away);

1215: AND NVL(l.quantity_delivered, 0) < l.quantity -- added for ATF_J
1216: AND l.organization_id = p_org_id
1217: AND l.header_id = h.header_id
1218: AND l.line_status <> inv_globals.g_to_status_closed
1219: AND h.move_order_type = inv_globals.g_move_order_put_away);
1220: -- AND Nvl(l.quantity_detailed,0) 1221:
1222: EXCEPTION
1223: WHEN NO_DATA_FOUND THEN

Line 1347: AND moh.move_order_type = inv_globals.g_move_order_put_away)));

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
1350: -- Need to delete MTLT before deleting MMTT
1351: -- Need tuning ???

Line 1370: AND moh.move_order_type = inv_globals.g_move_order_put_away)));

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
1373: WHERE move_order_line_id IN(
1374: SELECT mol.line_id

Line 1383: AND moh.move_order_type = inv_globals.g_move_order_put_away));

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
1386: SET mol.line_status = inv_globals.g_to_status_closed
1387: WHERE mol.lpn_id = l_lpn_id

Line 1386: SET mol.line_status = inv_globals.g_to_status_closed

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
1386: SET mol.line_status = inv_globals.g_to_status_closed
1387: WHERE mol.lpn_id = l_lpn_id
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

Line 1394: AND moh.move_order_type = inv_globals.g_move_order_put_away);

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
1397: mydebug('suggestions_pub: after getting sub and loc');
1398: mydebug('suggestions_pub: Loc' || l_m_loc);

Line 1535: AND mol.line_status <> inv_globals.g_to_status_closed;

1531: , to_locator_id = p_locator_id
1532: , quantity_detailed = NULL
1533: WHERE organization_id = p_org_id
1534: AND lpn_id = l_lpn_id
1535: AND mol.line_status <> inv_globals.g_to_status_closed;
1536: END IF;
1537:
1538: END IF; -- (l_lpn_context = 1)
1539:

Line 6955: , inv_globals.g_type_container_pack

6951: AND NOT wlpn.license_plate_number = NVL(p_from_lpn, -999)
6952: AND inv_material_status_grp.is_status_applicable(
6953: 'TRUE'
6954: , NULL
6955: , inv_globals.g_type_container_pack
6956: , NULL
6957: , NULL
6958: , p_org_id
6959: , NULL

Line 6969: , inv_globals.g_type_container_pack

6965: ) = 'Y'
6966: AND inv_material_status_grp.is_status_applicable(
6967: 'TRUE'
6968: , NULL
6969: , inv_globals.g_type_container_pack
6970: , NULL
6971: , NULL
6972: , p_org_id
6973: , NULL

Line 7011: AND mol.line_status <> inv_globals.g_to_status_closed

7007: SELECT COUNT(1)
7008: INTO l_count
7009: FROM mtl_txn_request_lines mol
7010: WHERE mol.lpn_id = l_to_lpn_id
7011: AND mol.line_status <> inv_globals.g_to_status_closed
7012: AND (
7013: (mol.quantity - NVL(mol.quantity_delivered, 0)) > (SELECT SUM(mmtt.transaction_quantity)
7014: FROM mtl_material_transactions_temp mmtt
7015: WHERE mmtt.move_order_line_id = mol.line_id)

Line 7355: WHERE moh.move_order_type = inv_globals.g_move_order_put_away

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;
7359:

Line 7473: SET mol.line_status = inv_globals.g_to_status_closed

7469: EXIT WHEN lpn_contents_csr%NOTFOUND;
7470:
7471: -- Close existing move orders detailed.
7472: UPDATE mtl_txn_request_lines mol
7473: SET mol.line_status = inv_globals.g_to_status_closed
7474: WHERE mol.lpn_id = l_lpn_id
7475: AND mol.organization_id = p_org_id
7476: AND mol.quantity_detailed > 0
7477: AND EXISTS

Line 7483: AND moh.move_order_type = inv_globals.g_move_order_put_away

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
7485: AND wlc.lpn_context = 1);
7486:
7487: IF (l_debug = 1) THEN

Line 8115: WHERE moh.move_order_type = inv_globals.g_move_order_put_away

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;
8119: