APPS.INV_PHY_INV_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 803: FROM WMS_LICENSE_PLATE_NUMBERS

799: */
800: BEGIN
801: SELECT outermost_lpn_id
802: INTO l_outermost_lpn_id
803: FROM WMS_LICENSE_PLATE_NUMBERS
804: WHERE lpn_id = p_parent_lpn_id;
805: EXCEPTION
806: WHEN OTHERS THEN
807: IF (l_debug = 1) THEN

Line 985: FROM WMS_LICENSE_PLATE_NUMBERS

981: */
982: BEGIN
983: SELECT outermost_lpn_id
984: INTO l_outermost_lpn_id
985: FROM WMS_LICENSE_PLATE_NUMBERS
986: WHERE lpn_id = p_parent_lpn_id;
987: EXCEPTION
988: WHEN OTHERS THEN
989: IF (l_debug = 1) THEN

Line 1370: FROM WMS_LICENSE_PLATE_NUMBERS

1366:
1367: BEGIN
1368: SELECT outermost_lpn_id
1369: INTO l_outermost_lpn_id
1370: FROM WMS_LICENSE_PLATE_NUMBERS
1371: WHERE lpn_id = p_parent_lpn_id;
1372: EXCEPTION
1373: WHEN OTHERS THEN
1374: IF (l_debug = 1) THEN

Line 1454: FROM WMS_LICENSE_PLATE_NUMBERS

1450: l_current_lpn NUMBER;
1451: l_temp_uom_code VARCHAR2(3);
1452: CURSOR nested_lpn_cursor IS
1453: SELECT *
1454: FROM WMS_LICENSE_PLATE_NUMBERS
1455: START WITH lpn_id = p_parent_lpn_id
1456: CONNECT BY parent_lpn_id = PRIOR lpn_id;
1457: CURSOR lpn_contents_cursor IS
1458: SELECT *