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 588: AND line_status <> inv_globals.g_to_status_closed

584: SELECT 1
585: FROM mtl_txn_request_lines
586: WHERE lpn_id = p_lpn
587: AND organization_id = p_org_id
588: AND line_status <> inv_globals.g_to_status_closed
589: AND NVL(project_id, -1) <> NVL(p_project_id, -1)
590: AND NVL(task_id, -1) <> NVL(p_task_id, -1));
591:
592: fnd_message.set_name('WMS', 'WMS_PROJ_LPN_COMINGLE');

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

722: l_trohdr_rec.created_by := fnd_global.user_id;
723: l_trohdr_rec.creation_date := SYSDATE;
724: l_trohdr_rec.date_required := SYSDATE;
725: l_trohdr_rec.from_subinventory_code := p_sub;
726: l_trohdr_rec.header_status := inv_globals.g_to_status_preapproved;
727: l_trohdr_rec.last_updated_by := fnd_global.user_id;
728: l_trohdr_rec.last_update_date := SYSDATE;
729: l_trohdr_rec.last_update_login := fnd_global.user_id;
730: l_trohdr_rec.organization_id := l_org_id;

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

729: l_trohdr_rec.last_update_login := fnd_global.user_id;
730: l_trohdr_rec.organization_id := l_org_id;
731: l_trohdr_rec.status_date := SYSDATE;
732: l_trohdr_rec.to_subinventory_code := NULL;
733: l_trohdr_rec.move_order_type := inv_globals.g_move_order_put_away;
734: l_trohdr_rec.db_flag := fnd_api.g_true;
735: l_trohdr_rec.operation := inv_globals.g_opr_create;
736: l_line_num := l_line_num + 1;
737: l_trolin_tbl(l_order_count).header_id := l_trohdr_rec.header_id;

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

731: l_trohdr_rec.status_date := SYSDATE;
732: l_trohdr_rec.to_subinventory_code := NULL;
733: l_trohdr_rec.move_order_type := inv_globals.g_move_order_put_away;
734: l_trohdr_rec.db_flag := fnd_api.g_true;
735: l_trohdr_rec.operation := inv_globals.g_opr_create;
736: l_line_num := l_line_num + 1;
737: l_trolin_tbl(l_order_count).header_id := l_trohdr_rec.header_id;
738: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;
739: l_trolin_tbl(l_order_count).creation_date := SYSDATE;

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

747: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
748: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;
749: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;
750: l_trolin_tbl(l_order_count).line_number := l_line_num;
751: l_trolin_tbl(l_order_count).line_status := inv_globals.g_to_status_preapproved;
752: l_trolin_tbl(l_order_count).organization_id := l_org_id;
753: l_trolin_tbl(l_order_count).quantity := l_qty;
754: l_trolin_tbl(l_order_count).status_date := SYSDATE;
755: l_trolin_tbl(l_order_count).to_subinventory_code := NULL;

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

754: l_trolin_tbl(l_order_count).status_date := SYSDATE;
755: l_trolin_tbl(l_order_count).to_subinventory_code := NULL;
756: l_trolin_tbl(l_order_count).uom_code := l_uom;
757: l_trolin_tbl(l_order_count).db_flag := fnd_api.g_true;
758: l_trolin_tbl(l_order_count).operation := inv_globals.g_opr_create;
759: l_trolin_tbl(l_order_count).lpn_id := p_lpn;
760: l_trolin_tbl(l_order_count).REFERENCE := l_ref;
761: l_trolin_tbl(l_order_count).reference_type_code := l_ref_type;
762: l_trolin_tbl(l_order_count).reference_id := l_ref_id;

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

773:
774: l_trolin_tbl(l_order_count).secondary_quantity := l_sec_qty; -- Added for OPM convergance
775: l_trolin_tbl(l_order_count).secondary_uom := l_sec_uom; -- Added for OPM convergance
776:
777: -- l_trolin_tbl(l_order_count).move_order_type:=inv_globals.g_move_order_put_away;
778: IF (p_txn_source_id <> fnd_api.g_miss_num) THEN
779: l_trolin_tbl(l_order_count).txn_source_id := l_txn_source_id;
780: END IF;
781:

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

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
1115: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
1116: AND mtrl.line_id = NVL(p_move_order_line_id, mtrl.line_id) -- added for ATF_J
1117: --BUG 5194761
1118: UNION ALL

Line 1115: AND mtrh.move_order_type = inv_globals.g_move_order_put_away

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
1115: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
1116: AND mtrl.line_id = NVL(p_move_order_line_id, mtrl.line_id) -- added for ATF_J
1117: --BUG 5194761
1118: UNION ALL
1119: SELECT mtrl.line_id

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

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
1140: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
1141: AND p_move_order_line_id IS NOT NULL
1142: AND mtrl.reference_detail_id = p_move_order_line_id
1143: --END BUG 5194761

Line 1140: AND mtrh.move_order_type = inv_globals.g_move_order_put_away

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
1140: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
1141: AND p_move_order_line_id IS NOT NULL
1142: AND mtrl.reference_detail_id = p_move_order_line_id
1143: --END BUG 5194761
1144: )mtrl

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

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
1362: AND l.header_id = h.header_id
1363: AND l.line_status <> inv_globals.g_to_status_closed
1364: AND h.move_order_type = inv_globals.g_move_order_put_away);
1365: -- AND Nvl(l.quantity_detailed,0) 1366:
1367: EXCEPTION

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

1360: AND NVL(l.quantity_delivered, 0) < l.quantity -- added for ATF_J
1361: AND l.organization_id = p_org_id
1362: AND l.header_id = h.header_id
1363: AND l.line_status <> inv_globals.g_to_status_closed
1364: AND h.move_order_type = inv_globals.g_move_order_put_away);
1365: -- AND Nvl(l.quantity_detailed,0) 1366:
1367: EXCEPTION
1368: WHEN NO_DATA_FOUND THEN

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

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

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

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

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

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

Line 1531: SET mol.line_status = inv_globals.g_to_status_closed

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

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

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

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

1676: , to_locator_id = p_locator_id
1677: , quantity_detailed = NULL
1678: WHERE organization_id = p_org_id
1679: AND lpn_id = l_lpn_id
1680: AND mol.line_status <> inv_globals.g_to_status_closed;
1681: END IF;
1682:
1683: END IF; -- (l_lpn_context = 1)
1684:

Line 7282: , inv_globals.g_type_container_pack

7278: AND NOT wlpn.license_plate_number = NVL(p_from_lpn, -999)
7279: AND inv_material_status_grp.is_status_applicable(
7280: 'TRUE'
7281: , NULL
7282: , inv_globals.g_type_container_pack
7283: , NULL
7284: , NULL
7285: , p_org_id
7286: , NULL

Line 7296: , inv_globals.g_type_container_pack

7292: ) = 'Y'
7293: AND inv_material_status_grp.is_status_applicable(
7294: 'TRUE'
7295: , NULL
7296: , inv_globals.g_type_container_pack
7297: , NULL
7298: , NULL
7299: , p_org_id
7300: , NULL

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

7334: SELECT COUNT(1)
7335: INTO l_count
7336: FROM mtl_txn_request_lines mol
7337: WHERE mol.lpn_id = l_to_lpn_id
7338: AND mol.line_status <> inv_globals.g_to_status_closed
7339: AND (
7340: (mol.quantity - NVL(mol.quantity_delivered, 0)) > (SELECT SUM(mmtt.transaction_quantity)
7341: FROM mtl_material_transactions_temp mmtt
7342: WHERE mmtt.move_order_line_id = mol.line_id)

Line 7682: WHERE moh.move_order_type = inv_globals.g_move_order_put_away

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

Line 7806: SET mol.line_status = inv_globals.g_to_status_closed

7802: EXIT WHEN lpn_contents_csr%NOTFOUND;
7803:
7804: -- Close existing move orders detailed.
7805: UPDATE mtl_txn_request_lines mol
7806: SET mol.line_status = inv_globals.g_to_status_closed
7807: WHERE mol.lpn_id = l_lpn_id
7808: AND mol.organization_id = p_org_id
7809: AND mol.quantity_detailed > 0
7810: AND EXISTS

Line 7816: AND moh.move_order_type = inv_globals.g_move_order_put_away

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
7818: AND wlc.lpn_context = 1);
7819:
7820: IF (l_debug = 1) THEN

Line 8456: WHERE moh.move_order_type = inv_globals.g_move_order_put_away

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