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_PICK_DROP_PVT dependencies on MTL_ALLOCATIONS_GTMP

Line 1723: DELETE mtl_allocations_gtmp;

1719: , l_api_name
1720: );
1721: END IF;
1722:
1723: DELETE mtl_allocations_gtmp;
1724:
1725: WHILE (ii <= jj)
1726: LOOP
1727:

Line 1891: INSERT INTO mtl_allocations_gtmp

1887: l_cur_group_num := l_cur_group_num + 1;
1888: g_current_drop_lpn.temp_id_group_ref(l_transaction_temp_id)
1889: := l_cur_group_num;
1890:
1891: INSERT INTO mtl_allocations_gtmp
1892: ( inventory_item_id
1893: , item_number
1894: , group_number
1895: , content_lpn

Line 1938: FROM mtl_allocations_gtmp mtg

1934: THEN
1935: BEGIN
1936: SELECT group_number
1937: INTO l_group_num
1938: FROM mtl_allocations_gtmp mtg
1939: WHERE mtg.inventory_item_id = c_mmtt_rec.inventory_item_id
1940: AND NVL(mtg.revision,'@@@@') = NVL(c_mmtt_rec.revision,'@@@@')
1941: AND NVL(mtg.inner_lpn,l_dum_lpn)
1942: = NVL(l_content_lpn, NVL(l_inner_lpn,l_dum_lpn))

Line 1958: UPDATE mtl_allocations_gtmp

1954:
1955: g_current_drop_lpn.temp_id_group_ref(l_transaction_temp_id)
1956: := l_group_num;
1957:
1958: UPDATE mtl_allocations_gtmp
1959: SET primary_quantity
1960: = primary_quantity + c_mmtt_rec.primary_quantity
1961: WHERE group_number = l_group_num;
1962:

Line 1979: INSERT INTO mtl_allocations_gtmp

1975: l_cur_group_num := l_cur_group_num + 1;
1976: g_current_drop_lpn.temp_id_group_ref(l_transaction_temp_id)
1977: := l_cur_group_num;
1978:
1979: INSERT INTO mtl_allocations_gtmp
1980: ( inventory_item_id
1981: , item_number
1982: , group_number
1983: , content_lpn

Line 2045: FROM mtl_allocations_gtmp mtg

2041:
2042: BEGIN
2043: SELECT group_number
2044: INTO l_group_num
2045: FROM mtl_allocations_gtmp mtg
2046: WHERE mtg.inventory_item_id = c_mmtt_rec.inventory_item_id
2047: AND mtg.lot_number = c_lot_dtl_rec.lot_number
2048: AND NVL(mtg.inner_lpn, l_dum_lpn)
2049: = NVL(l_inner_lpn, l_dum_lpn)

Line 2081: UPDATE mtl_allocations_gtmp

2077: , l_api_name
2078: );
2079: END IF;
2080:
2081: UPDATE mtl_allocations_gtmp
2082: SET primary_quantity
2083: = primary_quantity + c_lot_dtl_rec.primary_quantity
2084: WHERE group_number = l_group_num;
2085: END IF;

Line 2108: INSERT INTO mtl_allocations_gtmp

2104: , l_api_name
2105: );
2106: END IF;
2107:
2108: INSERT INTO mtl_allocations_gtmp
2109: ( inventory_item_id
2110: , item_number
2111: , group_number
2112: , content_lpn

Line 2169: INSERT INTO mtl_allocations_gtmp

2165: , l_api_name
2166: );
2167: END IF;
2168:
2169: INSERT INTO mtl_allocations_gtmp
2170: ( inventory_item_id
2171: , item_number
2172: , group_number
2173: , content_lpn

Line 2225: FROM mtl_allocations_gtmp mtg

2221: --
2222: BEGIN
2223: SELECT group_number
2224: INTO l_group_num
2225: FROM mtl_allocations_gtmp mtg
2226: WHERE mtg.inventory_item_id = c_mmtt_rec.inventory_item_id
2227: AND NVL(mtg.revision,'@@@@') = NVL(c_mmtt_rec.revision,'@@@@')
2228: AND NVL(mtg.inner_lpn, l_dum_lpn)
2229: = NVL(l_inner_lpn, l_dum_lpn)

Line 2265: INSERT INTO mtl_allocations_gtmp

2261: , l_api_name
2262: );
2263: END IF;
2264:
2265: INSERT INTO mtl_allocations_gtmp
2266: ( inventory_item_id
2267: , item_number
2268: , group_number
2269: , content_lpn

Line 2334: FROM mtl_allocations_gtmp mtg

2330:
2331: BEGIN
2332: SELECT group_number
2333: INTO l_group_num
2334: FROM mtl_allocations_gtmp mtg
2335: WHERE mtg.inventory_item_id = c_mmtt_rec.inventory_item_id
2336: AND NVL(mtg.revision,'@@@@') = NVL(c_mmtt_rec.revision,'@@@@')
2337: AND mtg.inner_lpn IS NULL
2338: AND mtg.content_lpn IS NULL;

Line 2353: UPDATE mtl_allocations_gtmp

2349:
2350: g_current_drop_lpn.temp_id_group_ref(l_transaction_temp_id)
2351: := l_group_num;
2352:
2353: UPDATE mtl_allocations_gtmp
2354: SET primary_quantity
2355: = primary_quantity + c_mmtt_rec.primary_quantity
2356: WHERE group_number = l_group_num;
2357:

Line 2524: INSERT INTO mtl_allocations_gtmp

2520: l_cur_group_num := l_cur_group_num + 1;
2521: g_current_drop_lpn.temp_id_group_ref(l_transaction_temp_id)
2522: := l_cur_group_num;
2523:
2524: INSERT INTO mtl_allocations_gtmp
2525: ( inventory_item_id
2526: , item_number
2527: , group_number
2528: , content_lpn

Line 4129: FROM mtl_allocations_gtmp;

4125:
4126: BEGIN
4127: SELECT count(*)
4128: INTO l_count
4129: FROM mtl_allocations_gtmp;
4130:
4131: IF l_debug = 1 THEN
4132: print_debug
4133: ( 'Count from mtl_allocations_gtmp: ' || to_char(l_count)

Line 4133: ( 'Count from mtl_allocations_gtmp: ' || to_char(l_count)

4129: FROM mtl_allocations_gtmp;
4130:
4131: IF l_debug = 1 THEN
4132: print_debug
4133: ( 'Count from mtl_allocations_gtmp: ' || to_char(l_count)
4134: , l_api_name
4135: );
4136: END IF;
4137:

Line 4167: FROM mtl_allocations_gtmp mag, mtl_system_items_vl msi

4163: , mag.primary_quantity
4164: , mag.primary_uom_code
4165: , mag.uom_lookup_code
4166: , msi.description
4167: FROM mtl_allocations_gtmp mag, mtl_system_items_vl msi
4168: WHERE mag.inventory_item_id = msi.inventory_item_id
4169: AND msi.ORGANIZATION_ID = p_organization_id
4170: ORDER BY group_number;
4171:

Line 4175: FROM mtl_allocations_gtmp;

4171:
4172: -- Added for bug 12853197
4173: SELECT Sum(primary_quantity)
4174: INTO g_total_qty
4175: FROM mtl_allocations_gtmp;
4176: ELSE
4177: IF l_debug = 1 THEN
4178: print_debug
4179: ( 'Invalid count of records in mtl_allocations_gtmp: '

Line 4179: ( 'Invalid count of records in mtl_allocations_gtmp: '

4175: FROM mtl_allocations_gtmp;
4176: ELSE
4177: IF l_debug = 1 THEN
4178: print_debug
4179: ( 'Invalid count of records in mtl_allocations_gtmp: '
4180: || to_char(l_count)
4181: , l_api_name
4182: );
4183: END IF;

Line 4637: FROM mtl_allocations_gtmp

4633: IF p_conf_uom_code IS NULL THEN
4634: OPEN x_lot_lov FOR
4635: SELECT lot_number
4636: , primary_quantity
4637: FROM mtl_allocations_gtmp
4638: WHERE inventory_item_id = p_item_id
4639: AND NVL(revision,'@@@@') = NVL(p_revision, '@@@@')
4640: AND NVL(inner_lpn,l_dum_lpn) = NVL(p_inner_lpn,l_dum_lpn)
4641: AND lot_number LIKE (p_lot_num);

Line 4654: FROM mtl_allocations_gtmp

4650: , p_conf_uom_code
4651: , NULL
4652: , NULL
4653: ) lot_qty
4654: FROM mtl_allocations_gtmp
4655: WHERE inventory_item_id = p_item_id
4656: AND NVL(revision,'@@@@') = NVL(p_revision, '@@@@')
4657: AND NVL(inner_lpn,l_dum_lpn) = NVL(p_inner_lpn,l_dum_lpn)
4658: AND lot_number LIKE (p_lot_num);

Line 4703: FROM mtl_allocations_gtmp

4699: END IF;
4700:
4701: OPEN x_serial_lov FOR
4702: SELECT serial_number
4703: FROM mtl_allocations_gtmp
4704: WHERE inventory_item_id = p_item_id
4705: AND NVL(revision,'@@@@') = NVL(p_revision, '@@@@')
4706: AND NVL(inner_lpn,l_dum_lpn) = NVL(p_inner_lpn,l_dum_lpn)
4707: AND NVL(lot_number,'@@@@') = NVL(p_lot_num, '@@@@')

Line 10280: DELETE mtl_allocations_gtmp;

10276: END IF;
10277:
10278: l_task_tbl.DELETE;
10279:
10280: DELETE mtl_allocations_gtmp;
10281:
10282: IF p_outer_lpn_done = 'TRUE'
10283: THEN
10284: IF ( (g_current_drop_lpn.multiple_drops = 'TRUE')