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

Line 1052: FROM WMS_LICENSE_PLATE_NUMBERS

1048: */
1049: BEGIN
1050: SELECT outermost_lpn_id
1051: INTO g_cc_entry.outermost_lpn_id
1052: FROM WMS_LICENSE_PLATE_NUMBERS
1053: WHERE lpn_id = g_cc_entry.parent_lpn_id;
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: IF(l_debug = 1) THEN

Line 1389: FROM WMS_LICENSE_PLATE_NUMBERS

1385: g_cc_entry.outermost_lpn_id := l_lpn_list ( 1 ).lpn_id;*/
1386: BEGIN
1387: SELECT outermost_lpn_id
1388: INTO g_cc_entry.outermost_lpn_id
1389: FROM WMS_LICENSE_PLATE_NUMBERS
1390: WHERE lpn_id = g_cc_entry.parent_lpn_id;
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: IF(l_debug = 1) THEN

Line 2694: FROM WMS_LICENSE_PLATE_NUMBERS

2690: lpn_context
2691: INTO l_lpn_subinv,
2692: l_lpn_locator_id,
2693: l_lpn_context
2694: FROM WMS_LICENSE_PLATE_NUMBERS
2695: WHERE lpn_id = g_cc_entry.parent_lpn_id ;
2696:
2697: IF ( l_debug = 1 ) THEN
2698: print_debug ( 'l_lpn_subinv: ===> ' || l_lpn_subinv );

Line 3245: FROM WMS_LICENSE_PLATE_NUMBERS

3241: l_lpn_locator_id,
3242: l_outermost_lpn_id, --13053297
3243: l_parent_lpn_id , --13053297
3244: l_lpn_context --13398739
3245: FROM WMS_LICENSE_PLATE_NUMBERS
3246: WHERE lpn_id = l_lpn_id;
3247:
3248: IF ( l_debug = 1 ) THEN
3249: print_debug ( 'l_lpn_subinv: ===> ' || l_lpn_subinv );

Line 3581: FROM WMS_LICENSE_PLATE_NUMBERS

3577: /* SELECT NVL ( subinventory_code, '###' ),
3578: NVL ( locator_id, -99 )
3579: INTO l_lpn_subinv,
3580: l_lpn_locator_id
3581: FROM WMS_LICENSE_PLATE_NUMBERS
3582: WHERE lpn_id = l_lpn_id;
3583: */
3584: --Bug 4346071 Added debug message
3585: IF ( l_debug = 1 ) THEN

Line 3835: FROM WMS_LICENSE_PLATE_NUMBERS

3831: SELECT NVL ( subinventory_code, '###' ),
3832: NVL ( locator_id, -99 )
3833: INTO l_lpn_subinv,
3834: l_lpn_locator_id
3835: FROM WMS_LICENSE_PLATE_NUMBERS
3836: WHERE lpn_id = l_lpn_id;
3837:
3838: IF ( l_debug = 1 ) THEN
3839: print_debug ( 'l_lpn_subinv: ===> ' || l_lpn_subinv );

Line 4133: FROM WMS_LICENSE_PLATE_NUMBERS

4129: SELECT NVL (subinventory_code, '###' ),
4130: NVL (locator_id, -99 )
4131: INTO l_lpn_subinv,
4132: l_lpn_locator_id
4133: FROM WMS_LICENSE_PLATE_NUMBERS
4134: WHERE lpn_id = g_cc_entry.parent_lpn_id;
4135:
4136: IF ( l_debug = 1 ) THEN
4137: print_debug ( '***l_lpn_subinv***' || l_lpn_subinv );

Line 4579: FROM WMS_LICENSE_PLATE_NUMBERS

4575: lpn_context
4576: INTO l_lpn_subinv,
4577: l_lpn_locator_id,
4578: l_lpn_context
4579: FROM WMS_LICENSE_PLATE_NUMBERS
4580: WHERE lpn_id = l_lpn_id ;
4581:
4582: IF ( l_debug = 1 ) THEN
4583: print_debug ( 'l_lpn_subinv: ===> ' || l_lpn_subinv );

Line 7368: FROM WMS_LICENSE_PLATE_NUMBERS

7364:
7365: CURSOR nested_lpn_cursor
7366: IS
7367: SELECT *
7368: FROM WMS_LICENSE_PLATE_NUMBERS
7369: START WITH lpn_id = p_parent_lpn_id
7370: CONNECT BY parent_lpn_id = PRIOR lpn_id;
7371:
7372: CURSOR lpn_contents_cursor

Line 7441: FROM wms_license_plate_numbers

7437: l_parent_lpn_id,
7438: l_sub,
7439: l_locator_id,
7440: l_org_id
7441: FROM wms_license_plate_numbers
7442: WHERE lpn_id = p_parent_lpn_id;
7443:
7444: IF ( l_debug = 1 ) THEN
7445: print_debug ( 'To Check If we have to call PackUnpack' );

Line 7635: FROM WMS_LICENSE_PLATE_NUMBERS

7631:
7632: SELECT
7633: lpn_context
7634: INTO l_lpn_context
7635: FROM WMS_LICENSE_PLATE_NUMBERS
7636: WHERE lpn_id = p_parent_lpn_id ;
7637:
7638: IF ( l_debug = 1 ) THEN
7639: print_debug ( 'l_lpn_context: => ' || l_lpn_context );

Line 9048: FROM WMS_LICENSE_PLATE_NUMBERS

9044: lpn_context
9045: INTO l_lpn_subinv,
9046: l_lpn_locator_id,
9047: l_lpn_context
9048: FROM WMS_LICENSE_PLATE_NUMBERS
9049: WHERE lpn_id = p_parent_lpn_id ;
9050:
9051: IF ( l_debug = 1 ) THEN
9052: print_debug ( 'l_lpn_subinv: ===> ' || l_lpn_subinv );

Line 10349: l_lpn_subinventory WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE%TYPE;

10345: IS
10346: l_system_quantity NUMBER;
10347: l_sec_system_quantity NUMBER;
10348: l_count_present_qty NUMBER;
10349: l_lpn_subinventory WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE%TYPE;
10350: l_lpn_loc_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;
10351: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
10352: BEGIN
10353: IF l_debug = 1 THEN

Line 10350: l_lpn_loc_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;

10346: l_system_quantity NUMBER;
10347: l_sec_system_quantity NUMBER;
10348: l_count_present_qty NUMBER;
10349: l_lpn_subinventory WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE%TYPE;
10350: l_lpn_loc_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;
10351: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
10352: BEGIN
10353: IF l_debug = 1 THEN
10354: print_debug('*** process_multiple_qty_only ***');

Line 10362: FROM wms_license_plate_numbers

10358: SELECT subinventory_code,
10359: locator_id
10360: INTO l_lpn_subinventory,
10361: l_lpn_loc_id
10362: FROM wms_license_plate_numbers
10363: WHERE lpn_id = g_cc_entry.parent_lpn_id;
10364:
10365: IF l_debug = 1 THEN
10366: print_debug('lpn_id: ' || g_cc_entry.parent_lpn_id || ', lpn_subinventory: ' || l_lpn_subinventory || ', lpn_loc_id: ' || l_lpn_loc_id);