DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WIP_LPN_COMPLETIONS_SERIALS

Line 3533: FROM wip_lpn_completions_serials

3529: -- tied to the MOL/MMTT line which we have to use
3530: AND (
3531: (l_transaction_source_type_id = 5
3532: AND serial_number IN(SELECT fm_serial_number
3533: FROM wip_lpn_completions_serials
3534: WHERE header_id = l_ref_id))
3535: OR l_transaction_source_type_id <> 5
3536: );
3537:

Line 3650: FROM wip_lpn_completions_serials

3646: l_transaction_source_type_id = 5
3647: AND serial_number IN
3648: (
3649: SELECT fm_serial_number
3650: FROM wip_lpn_completions_serials
3651: WHERE header_id = l_ref_id
3652: )
3653: )
3654: OR l_transaction_source_type_id <> 5

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

4445: (p_entire_lpn = 'Y' AND l_lpn_context IN (1,2))
4446: ) THEN
4447: -- Capture serial info for WIP transactions
4448: /* nsinghi - GME-WMS Integration. Added additional check for l_process_flag.
4449: Update Serial attrs from wip_lpn_completions_serials table only for discrete orgs. */
4450:
4451: IF (l_transaction_source_type_id = 5 AND l_process_flag = 'N') THEN
4452: IF (l_debug = 1) THEN
4453: mydebug('complete_putaway: Capture serial atts from wip tables');