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.INV_MATERIAL_STATUS_GRP dependencies on MTL_MATERIAL_STATUS_HISTORY

Line 1046: FROM mtl_material_status_history

1042: --ERES Deferred
1043: --IF g_eres_enabled <> 'N' THEN
1044: BEGIN
1045: SELECT status_id INTO l_new_status_id
1046: FROM mtl_material_status_history
1047: where organization_id = p_organization_id
1048: and zone_code = p_sub_code
1049: and locator_id is null
1050: and inventory_item_id is null

Line 1072: FROM mtl_material_status_history

1068: --ERES Deferred
1069: -- IF g_eres_enabled <> 'N' THEN
1070: BEGIN
1071: SELECT status_id INTO l_new_status_id
1072: FROM mtl_material_status_history
1073: where inventory_item_id = p_inventory_item_id
1074: and organization_id = p_organization_id
1075: and zone_code = p_sub_code
1076: and lot_number is null

Line 1350: FROM mtl_material_status_history

1346: --ERES Deferred
1347: -- IF g_eres_enabled <> 'N' THEN
1348: BEGIN
1349: SELECT status_id INTO l_new_status_id
1350: FROM mtl_material_status_history
1351: where organization_id = p_organization_id
1352: and locator_id = p_locator_id
1353: and inventory_item_id is null
1354: and lot_number is null

Line 1404: FROM mtl_material_status_history

1400: --ERES Deferred
1401: -- IF g_eres_enabled <> 'N' THEN
1402: BEGIN
1403: SELECT status_id INTO l_new_status_id
1404: FROM mtl_material_status_history
1405: where inventory_item_id = p_inventory_item_id
1406: and organization_id = p_organization_id
1407: and lot_number is null
1408: and locator_id = p_locator_id

Line 1676: FROM mtl_material_status_history

1672: --ERES Deferred
1673: --IF g_eres_enabled <> 'N' THEN
1674: BEGIN
1675: SELECT status_id INTO l_new_status_id
1676: FROM mtl_material_status_history
1677: where inventory_item_id = p_inventory_item_id
1678: and organization_id = p_organization_id
1679: and lot_number = p_lot_number
1680: and zone_code is null

Line 1732: FROM mtl_material_status_history

1728: --ERES Deferred
1729: -- IF g_eres_enabled <> 'N' THEN
1730: BEGIN
1731: SELECT status_id INTO l_new_status_id
1732: FROM mtl_material_status_history
1733: where inventory_item_id = p_inventory_item_id
1734: and organization_id = p_organization_id
1735: and zone_code = p_sub_code
1736: and lot_number = p_lot_number

Line 1952: FROM mtl_material_status_history

1948: END;
1949:
1950: BEGIN
1951: SELECT status_id INTO l_new_status_id
1952: FROM mtl_material_status_history
1953: where inventory_item_id = p_inventory_item_id
1954: and organization_id = p_organization_id
1955: and serial_number = p_serial_number
1956: and zone_code is null

Line 2321: -- the table : mtl_material_status_history

2317: if (g_debug = 1) then
2318: inv_trx_util_pub.TRACE('src status ex ' || m_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2319: end if;
2320: -- Calling the insert procedure to insert the status of the new onhand record into
2321: -- the table : mtl_material_status_history
2322: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2323: ,p_lpn_id, m_status_id, p_lock_id);
2324:
2325: return m_status_id;

Line 2431: -- the table : mtl_material_status_history

2427: if (g_debug = 1) then
2428: inv_trx_util_pub.TRACE('src status ex ' || p_src_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2429: end if;
2430: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2431: -- the table : mtl_material_status_history
2432: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2433: ,p_lpn_id, p_src_status_id, p_lock_id);
2434:
2435: return p_src_status_id;

Line 2444: -- the table : mtl_material_status_history

2440: if (l_serial_controlled <> 0) then
2441: return null;
2442: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then
2443: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2444: -- the table : mtl_material_status_history
2445: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2446: ,p_lpn_id, inv_cache.item_rec.default_lot_status_id, p_lock_id);
2447:
2448: return inv_cache.item_rec.default_lot_status_id;

Line 2451: -- the table : mtl_material_status_history

2447:
2448: return inv_cache.item_rec.default_lot_status_id;
2449: elsif (inv_cache.item_rec.default_material_status_id is not null) then
2450: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2451: -- the table : mtl_material_status_history
2452: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2453: ,p_lpn_id, inv_cache.item_rec.default_material_status_id, p_lock_id);
2454:
2455: return inv_cache.item_rec.default_material_status_id;

Line 2463: -- the table : mtl_material_status_history

2459: if p_loc_id is not null then
2460: if inv_cache.set_loc_rec(p_organization_id, p_loc_id) then
2461: if (inv_cache.loc_rec.status_id is not null) then
2462: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2463: -- the table : mtl_material_status_history
2464: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2465: ,p_lpn_id, inv_cache.loc_rec.status_id, p_lock_id);
2466:
2467: return inv_cache.loc_rec.status_id;

Line 2472: -- the table : mtl_material_status_history

2468: else -- Locator is dynamic
2469: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2470: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
2471: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2472: -- the table : mtl_material_status_history
2473: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2474: ,p_lpn_id, inv_cache.tosub_rec.default_loc_status_id, p_lock_id);
2475:
2476: return inv_cache.tosub_rec.default_loc_status_id;

Line 2484: -- the table : mtl_material_status_history

2480: else -- Locator is dynamic
2481: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2482: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
2483: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2484: -- the table : mtl_material_status_history
2485: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2486: ,p_lpn_id, inv_cache.tosub_rec.default_loc_status_id, p_lock_id);
2487:
2488: return inv_cache.tosub_rec.default_loc_status_id;

Line 2491: -- the table : mtl_material_status_history

2487:
2488: return inv_cache.tosub_rec.default_loc_status_id;
2489: else
2490: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2491: -- the table : mtl_material_status_history
2492: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2493: ,p_lpn_id, inv_cache.tosub_rec.status_id, p_lock_id);
2494:
2495: return inv_cache.tosub_rec.status_id;

Line 2504: -- the table : mtl_material_status_history

2500:
2501: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2502: if (inv_cache.tosub_rec.status_id is not null) then
2503: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2504: -- the table : mtl_material_status_history
2505: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2506: ,p_lpn_id, inv_cache.tosub_rec.status_id, p_lock_id);
2507:
2508: return inv_cache.tosub_rec.status_id;

Line 2514: -- the table : mtl_material_status_history

2510: end if;
2511:
2512: if inv_cache.set_org_rec(p_organization_id) then
2513: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2514: -- the table : mtl_material_status_history
2515: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2516: ,p_lpn_id, inv_cache.org_rec.default_status_id, p_lock_id);
2517:
2518: return inv_cache.org_rec.default_status_id;