APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WIP_LPN_COMPLETIONS_SERIALS

Line 3329: FROM wip_lpn_completions_serials

3325: -- tied to the MOL/MMTT line which we have to use
3326: AND (
3327: (l_transaction_source_type_id = 5
3328: AND serial_number IN(SELECT fm_serial_number
3329: FROM wip_lpn_completions_serials
3330: WHERE header_id = l_ref_id))
3331: OR l_transaction_source_type_id <> 5
3332: );
3333:

Line 3446: FROM wip_lpn_completions_serials

3442: l_transaction_source_type_id = 5
3443: AND serial_number IN
3444: (
3445: SELECT fm_serial_number
3446: FROM wip_lpn_completions_serials
3447: WHERE header_id = l_ref_id
3448: )
3449: )
3450: OR l_transaction_source_type_id <> 5

Line 4229: Update Serial attrs from wip_lpn_completions_serials table only for discrete orgs. */

4225: (p_entire_lpn = 'Y' AND l_lpn_context IN (1,2))
4226: ) THEN
4227: -- Capture serial info for WIP transactions
4228: /* nsinghi - GME-WMS Integration. Added additional check for l_process_flag.
4229: Update Serial attrs from wip_lpn_completions_serials table only for discrete orgs. */
4230:
4231: IF (l_transaction_source_type_id = 5 AND l_process_flag = 'N') THEN
4232: IF (l_debug = 1) THEN
4233: mydebug('complete_putaway: Capture serial atts from wip tables');