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_CONTAINER2_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 56: FROM WMS_LICENSE_PLATE_NUMBERS

52: SELECT 'Check for empty LPN'
53: FROM DUAL
54: WHERE EXISTS
55: (SELECT 'Child LPN'
56: FROM WMS_LICENSE_PLATE_NUMBERS
57: WHERE parent_lpn_id = p_lpn_id);
58: CURSOR c_lpn_contents IS
59: SELECT 'Check for empty LPN'
60: FROM DUAL

Line 109: /* Check WMS_LICENSE_PLATE_NUMBERS table for any item stored within the LPN */

105: END IF;
106:
107: /* End of input validation */
108:
109: /* Check WMS_LICENSE_PLATE_NUMBERS table for any item stored within the LPN */
110: OPEN c_lpn;
111: FETCH c_lpn INTO l_lpn_exist;
112: IF c_lpn%FOUND THEN
113: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_NON_EMPTY_LPN');

Line 140: DELETE FROM WMS_LICENSE_PLATE_NUMBERS

136: END IF;
137: CLOSE c_lpn_serial_contents;
138:
139: /* Nothing found within the LPN so okay to purge it now */
140: DELETE FROM WMS_LICENSE_PLATE_NUMBERS
141: WHERE lpn_id = p_lpn_id;
142:
143: /* Check if the LPN history of this should be deleted or not */
144: IF (p_purge_history = 1) THEN

Line 233: FROM WMS_LICENSE_PLATE_NUMBERS

229: -- Bug# 1546081
230: -- SELECT *
231: SELECT lpn_id, parent_lpn_id, inventory_item_id, organization_id,
232: revision, lot_number, serial_number, cost_group_id
233: FROM WMS_LICENSE_PLATE_NUMBERS
234: WHERE Level <= p_explosion_level
235: START WITH lpn_id = p_lpn_id
236: CONNECT BY parent_lpn_id = PRIOR lpn_id;
237: CURSOR all_nested_lpn_cursor IS

Line 242: FROM WMS_LICENSE_PLATE_NUMBERS

238: -- Bug# 1546081
239: -- SELECT *
240: SELECT lpn_id, parent_lpn_id, inventory_item_id, organization_id,
241: revision, lot_number, serial_number, cost_group_id
242: FROM WMS_LICENSE_PLATE_NUMBERS
243: START WITH lpn_id = p_lpn_id
244: CONNECT BY parent_lpn_id = PRIOR lpn_id;
245: CURSOR lpn_contents_cursor IS
246: -- Bug# 1546081

Line 564: UPDATE WMS_LICENSE_PLATE_NUMBERS

560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562: /* End of input validation */
563:
564: UPDATE WMS_LICENSE_PLATE_NUMBERS
565: SET parent_lpn_id = p_lpn_id_dest
566: WHERE parent_lpn_id = p_lpn_id_source;
567:
568: UPDATE WMS_LPN_CONTENTS

Line 1015: FROM WMS_LICENSE_PLATE_NUMBERS

1011: l_Dummy INTEGER;
1012: l_temp_lpn NUMBER;
1013: CURSOR nested_parent_lpn_cursor IS
1014: SELECT *
1015: FROM WMS_LICENSE_PLATE_NUMBERS
1016: START WITH lpn_id = p_lpn_id
1017: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1018: l_current_lpn NUMBER;
1019: CURSOR nested_parent_lpn_cursor_2 IS

Line 1021: FROM WMS_LICENSE_PLATE_NUMBERS

1017: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1018: l_current_lpn NUMBER;
1019: CURSOR nested_parent_lpn_cursor_2 IS
1020: SELECT *
1021: FROM WMS_LICENSE_PLATE_NUMBERS
1022: START WITH lpn_id = l_current_lpn
1023: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1024: l_lpn WMS_CONTAINER_PUB.LPN;
1025: l_temp_table WMS_CONTAINER_PUB.LPN_Table_Type;

Line 1265: TYPE lpn_id_table IS TABLE OF WMS_LICENSE_PLATE_NUMBERS.LPN_ID%TYPE

1261: IS
1262: l_api_name CONSTANT VARCHAR2(30) := 'Get_LPN_List';
1263: l_api_version CONSTANT NUMBER := 1.0;
1264: l_SelectStmt VARCHAR2(500);
1265: TYPE lpn_id_table IS TABLE OF WMS_LICENSE_PLATE_NUMBERS.LPN_ID%TYPE
1266: INDEX BY BINARY_INTEGER;
1267: l_temp_table lpn_id_table;
1268: l_CursorID INTEGER;
1269: l_Dummy INTEGER;

Line 1270: l_temp_record WMS_LICENSE_PLATE_NUMBERS%ROWTYPE;

1266: INDEX BY BINARY_INTEGER;
1267: l_temp_table lpn_id_table;
1268: l_CursorID INTEGER;
1269: l_Dummy INTEGER;
1270: l_temp_record WMS_LICENSE_PLATE_NUMBERS%ROWTYPE;
1271: l_index BINARY_INTEGER := 1;
1272: l_list_index BINARY_INTEGER := 1;
1273: l_temp_lpn NUMBER;
1274: l_org INV_Validate.ORG;

Line 1285: FROM WMS_LICENSE_PLATE_NUMBERS

1281: WHERE parent_lpn_id = l_temp_lpn
1282: AND NVL(serial_summary_entry, 2) = 2;
1283: CURSOR container_cursor IS
1284: SELECT parent_lpn_id
1285: FROM WMS_LICENSE_PLATE_NUMBERS
1286: WHERE parent_lpn_id = l_temp_lpn;
1287:
1288: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1289: BEGIN

Line 1328: FROM WMS_LICENSE_PLATE_NUMBERS a, WMS_LPN_CONTENTS b WHERE ';

1324: -- WMS_LPN_CONTENTS table to get all the LPN's that store the
1325: -- given item with the specified parameters.
1326:
1327: l_SelectStmt := 'SELECT a.lpn_id
1328: FROM WMS_LICENSE_PLATE_NUMBERS a, WMS_LPN_CONTENTS b WHERE ';
1329:
1330: IF (p_lpn_context IS NOT NULL) THEN
1331: l_SelectStmt := l_SelectStmt || 'a.lpn_context = ' ||
1332: p_lpn_context || ' AND ';

Line 1433: FROM WMS_LICENSE_PLATE_NUMBERS

1429: FETCH container_cursor INTO l_dummy_lpn;
1430: IF container_cursor%NOTFOUND THEN
1431: SELECT *
1432: INTO l_temp_record
1433: FROM WMS_LICENSE_PLATE_NUMBERS
1434: WHERE lpn_id = l_temp_lpn;
1435: x_lpn_list(l_list_index) := l_temp_record;
1436: l_list_index := l_list_index + 1;
1437: END IF;

Line 1521: lpn_id wms_license_plate_numbers.lpn_id%TYPE,

1517: l_drop_lpn_delivery_id NUMBER := NULL;
1518:
1519: TYPE lpn_rectype is RECORD
1520: (
1521: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
1522: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
1523: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
1524: locator_id wms_license_plate_numbers.locator_id%TYPE
1525: );

Line 1522: lpn_context wms_license_plate_numbers.lpn_context%TYPE,

1518:
1519: TYPE lpn_rectype is RECORD
1520: (
1521: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
1522: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
1523: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
1524: locator_id wms_license_plate_numbers.locator_id%TYPE
1525: );
1526: drop_lpn_rec lpn_rectype;

Line 1523: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,

1519: TYPE lpn_rectype is RECORD
1520: (
1521: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
1522: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
1523: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
1524: locator_id wms_license_plate_numbers.locator_id%TYPE
1525: );
1526: drop_lpn_rec lpn_rectype;
1527:

Line 1524: locator_id wms_license_plate_numbers.locator_id%TYPE

1520: (
1521: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
1522: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
1523: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
1524: locator_id wms_license_plate_numbers.locator_id%TYPE
1525: );
1526: drop_lpn_rec lpn_rectype;
1527:
1528: CURSOR drop_lpn_cursor IS

Line 1533: FROM wms_license_plate_numbers

1529: SELECT lpn_id,
1530: lpn_context,
1531: subinventory_code,
1532: locator_id
1533: FROM wms_license_plate_numbers
1534: WHERE license_plate_number = p_drop_lpn
1535: AND organization_id = p_organization_id;
1536:
1537: CURSOR pick_delivery_cursor IS

Line 1552: wms_license_plate_numbers lpn

1548: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
1549: SELECT wda.delivery_id
1550: FROM wsh_delivery_assignments wda,
1551: wsh_delivery_details wdd,
1552: wms_license_plate_numbers lpn
1553: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
1554: AND wdd.lpn_id = lpn.lpn_id
1555: AND lpn.outermost_lpn_id = l_lpn_id
1556: AND wdd.organization_id = p_organization_id ;

Line 1603: /* UPDATE wms_license_plate_numbers

1599: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED THEN
1600: --
1601: -- Update the context to "Resides in Inventory" (1)
1602: --
1603: /* UPDATE wms_license_plate_numbers
1604: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
1605: WHERE lpn_id = drop_lpn_rec.lpn_id;*/
1606:
1607: IF (l_debug = 1) THEN

Line 1748: lpn_id wms_license_plate_numbers.lpn_id%TYPE,

1744: l_drop_lpn_delivery_id NUMBER := NULL;
1745:
1746: TYPE lpn_rectype is RECORD
1747: (
1748: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
1749: lpn_context wms_license_plate_numbers.lpn_context%TYPE
1750: );
1751: drop_lpn_rec lpn_rectype;
1752:

Line 1749: lpn_context wms_license_plate_numbers.lpn_context%TYPE

1745:
1746: TYPE lpn_rectype is RECORD
1747: (
1748: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
1749: lpn_context wms_license_plate_numbers.lpn_context%TYPE
1750: );
1751: drop_lpn_rec lpn_rectype;
1752:
1753: CURSOR drop_lpn_cursor IS

Line 1756: FROM wms_license_plate_numbers

1752:
1753: CURSOR drop_lpn_cursor IS
1754: SELECT lpn_id,
1755: lpn_context
1756: FROM wms_license_plate_numbers
1757: WHERE license_plate_number = p_drop_lpn
1758: AND organization_id = p_organization_id;
1759:
1760: CURSOR child_lpns_cursor(l_lpn_id IN NUMBER) IS

Line 1762: FROM WMS_LICENSE_PLATE_NUMBERS

1758: AND organization_id = p_organization_id;
1759:
1760: CURSOR child_lpns_cursor(l_lpn_id IN NUMBER) IS
1761: SELECT lpn_id
1762: FROM WMS_LICENSE_PLATE_NUMBERS
1763: START WITH lpn_id = l_lpn_id
1764: CONNECT BY parent_lpn_id = PRIOR lpn_id;
1765: child_lpns_rec child_lpns_cursor%ROWTYPE;
1766:

Line 1857: UPDATE wms_license_plate_numbers

1853: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED THEN
1854: --
1855: -- Update the context to "Resides in Inventory" (1)
1856: --
1857: UPDATE wms_license_plate_numbers
1858: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
1859: WHERE lpn_id = drop_lpn_rec.lpn_id;
1860: IF (l_debug = 1) THEN
1861: mdebug ('Drop LPN is pre-generated, no checking required.');

Line 2107: wms_license_plate_numbers wlpn

2103: l_drop_loc_c IN NUMBER ) IS
2104: SELECT wlpn.outermost_lpn_id
2105: FROM wsh_delivery_assignments wda,
2106: wsh_delivery_details wdd,
2107: wms_license_plate_numbers wlpn
2108: WHERE wda.delivery_id = l_delivery_id_c
2109: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
2110: AND wdd.organization_id = p_organization_id
2111: AND wdd.lpn_id = wlpn.lpn_id

Line 2181: wms_license_plate_numbers WHERE lpn_id = l_lpn_id;

2177:
2178:
2179: BEGIN
2180: SELECT license_plate_number INTO x_lpn_number FROM
2181: wms_license_plate_numbers WHERE lpn_id = l_lpn_id;
2182:
2183: EXCEPTION
2184: WHEN NO_DATA_FOUND THEN
2185: x_lpn_number := NULL;