APPS.INV_CYC_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 957: FROM WMS_LICENSE_PLATE_NUMBERS

953: */
954: BEGIN
955: SELECT outermost_lpn_id
956: INTO g_cc_entry.outermost_lpn_id
957: FROM WMS_LICENSE_PLATE_NUMBERS
958: WHERE lpn_id = g_cc_entry.parent_lpn_id;
959: EXCEPTION
960: WHEN OTHERS THEN
961: IF(l_debug = 1) THEN

Line 1193: FROM WMS_LICENSE_PLATE_NUMBERS

1189: g_cc_entry.outermost_lpn_id := l_lpn_list ( 1 ).lpn_id;*/
1190: BEGIN
1191: SELECT outermost_lpn_id
1192: INTO g_cc_entry.outermost_lpn_id
1193: FROM WMS_LICENSE_PLATE_NUMBERS
1194: WHERE lpn_id = g_cc_entry.parent_lpn_id;
1195: EXCEPTION
1196: WHEN OTHERS THEN
1197: IF(l_debug = 1) THEN

Line 2447: FROM WMS_LICENSE_PLATE_NUMBERS

2443: lpn_context
2444: INTO l_lpn_subinv,
2445: l_lpn_locator_id,
2446: l_lpn_context
2447: FROM WMS_LICENSE_PLATE_NUMBERS
2448: WHERE lpn_id = g_cc_entry.parent_lpn_id ;
2449:
2450: IF ( l_debug = 1 ) THEN
2451: print_debug ( 'l_lpn_subinv: ===> ' || l_lpn_subinv );

Line 2988: FROM WMS_LICENSE_PLATE_NUMBERS

2984: SELECT NVL ( subinventory_code, '###' ),
2985: NVL ( locator_id, -99 )
2986: INTO l_lpn_subinv,
2987: l_lpn_locator_id
2988: FROM WMS_LICENSE_PLATE_NUMBERS
2989: WHERE lpn_id = l_lpn_id;
2990:
2991: IF ( l_debug = 1 ) THEN
2992: print_debug ( 'l_lpn_subinv: ===> ' || l_lpn_subinv );

Line 3294: FROM WMS_LICENSE_PLATE_NUMBERS

3290: /* SELECT NVL ( subinventory_code, '###' ),
3291: NVL ( locator_id, -99 )
3292: INTO l_lpn_subinv,
3293: l_lpn_locator_id
3294: FROM WMS_LICENSE_PLATE_NUMBERS
3295: WHERE lpn_id = l_lpn_id;
3296:
3297: --Bug 4346071 Added debug message
3298: IF ( l_debug = 1 ) THEN

Line 3536: FROM WMS_LICENSE_PLATE_NUMBERS

3532: SELECT NVL ( subinventory_code, '###' ),
3533: NVL ( locator_id, -99 )
3534: INTO l_lpn_subinv,
3535: l_lpn_locator_id
3536: FROM WMS_LICENSE_PLATE_NUMBERS
3537: WHERE lpn_id = l_lpn_id;
3538:
3539: --Bug4958692.sub and loc are missing in LPN.So no need of doing sub transfer.
3540: IF l_lpn_subinv <> '###' AND l_lpn_locator_id <> -99 THEN

Line 3820: FROM WMS_LICENSE_PLATE_NUMBERS

3816: SELECT NVL (subinventory_code, '###' ),
3817: NVL (locator_id, -99 )
3818: INTO l_lpn_subinv,
3819: l_lpn_locator_id
3820: FROM WMS_LICENSE_PLATE_NUMBERS
3821: WHERE lpn_id = g_cc_entry.parent_lpn_id;
3822:
3823: IF ( l_debug = 1 ) THEN
3824: print_debug ( '***l_lpn_subinv***' || l_lpn_subinv );

Line 4257: FROM WMS_LICENSE_PLATE_NUMBERS

4253: lpn_context
4254: INTO l_lpn_subinv,
4255: l_lpn_locator_id,
4256: l_lpn_context
4257: FROM WMS_LICENSE_PLATE_NUMBERS
4258: WHERE lpn_id = l_lpn_id ;
4259:
4260: IF ( l_debug = 1 ) THEN
4261: print_debug ( 'l_lpn_subinv: ===> ' || l_lpn_subinv );

Line 4586: FROM WMS_LICENSE_PLATE_NUMBERS

4582: lpn_context
4583: INTO l_lpn_subinv,
4584: l_lpn_locator_id,
4585: l_lpn_context
4586: FROM WMS_LICENSE_PLATE_NUMBERS
4587: WHERE lpn_id = l_lpn_id ;
4588:
4589: IF ( l_debug = 1 ) THEN
4590: print_debug ( 'l_lpn_subinv: ===> ' || l_lpn_subinv );

Line 7252: FROM WMS_LICENSE_PLATE_NUMBERS

7248:
7249: CURSOR nested_lpn_cursor
7250: IS
7251: SELECT *
7252: FROM WMS_LICENSE_PLATE_NUMBERS
7253: START WITH lpn_id = p_parent_lpn_id
7254: CONNECT BY parent_lpn_id = PRIOR lpn_id;
7255:
7256: CURSOR lpn_contents_cursor

Line 7446: FROM WMS_LICENSE_PLATE_NUMBERS

7442:
7443: SELECT
7444: lpn_context
7445: INTO l_lpn_context
7446: FROM WMS_LICENSE_PLATE_NUMBERS
7447: WHERE lpn_id = p_parent_lpn_id ;
7448:
7449: IF ( l_debug = 1 ) THEN
7450: print_debug ( 'l_lpn_context: => ' || l_lpn_context );

Line 8829: FROM WMS_LICENSE_PLATE_NUMBERS

8825: lpn_context
8826: INTO l_lpn_subinv,
8827: l_lpn_locator_id,
8828: l_lpn_context
8829: FROM WMS_LICENSE_PLATE_NUMBERS
8830: WHERE lpn_id = p_parent_lpn_id ;
8831:
8832: IF ( l_debug = 1 ) THEN
8833: print_debug ( 'l_lpn_subinv: ===> ' || l_lpn_subinv );