APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WIP_LPN_COMPLETIONS

Line 2186: Also added check in If statement to not refer to Wip_Lpn_Completions table for discrete Orgs.

2182: RAISE fnd_api.g_exc_error;
2183: END IF;
2184:
2185: /* nsinghi - GME-WMS Integration. Added the following select stmt to determine if Process Org.
2186: Also added check in If statement to not refer to Wip_Lpn_Completions table for discrete Orgs.
2187: Also added the If statement to update transaction_source_id in MMTT for Process Orgs. */
2188:
2189: SELECT NVL(process_enabled_flag, 'N') INTO l_process_flag
2190: FROM mtl_parameters WHERE organization_id = p_org_id;

Line 2200: FROM wip_lpn_completions

2196: , wip_entity_id
2197: INTO l_completion_txn_id
2198: , l_flow_schedule
2199: , l_transaction_source_id
2200: FROM wip_lpn_completions
2201: WHERE header_id = l_ref_id;
2202:
2203: UPDATE mtl_material_transactions_temp
2204: SET completion_transaction_id = l_completion_txn_id

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 4074: Update Lot attrs from wip_lpn_completions_lots table only for discrete orgs. */

4070:
4071: -- Capture lot info for WIP transactions
4072:
4073: /* nsinghi - GME-WMS Integration. Added additional check for l_process_flag.
4074: Update Lot attrs from wip_lpn_completions_lots table only for discrete orgs. */
4075:
4076: IF (l_transaction_source_type_id = 5 AND l_process_flag = 'N') THEN
4077: IF (l_debug = 1) THEN
4078: mydebug('complete_putaway: Capture lot atts from wip tables');

Line 4093: FROM wip_lpn_completions

4089: --Start Bug 6356147
4090: -- Update MMTT for WIP flow completions
4091: SELECT DECODE(wip_entity_type, 4, 'Y', 'N')
4092: INTO l_flow_schedule
4093: FROM wip_lpn_completions
4094: WHERE header_id = l_ref_id;
4095:
4096: IF (l_debug = 1) THEN
4097: mydebug('l_flow_schedule => ' || l_flow_schedule);

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');

Line 8456: FROM wip_lpn_completions

8452: IF (v_mo_line.transaction_source_type_id = 5 AND
8453: v_mo_line.transaction_type_id = 44) THEN
8454: SELECT NVL(completion_transaction_id, -999)
8455: INTO l_completion_txn_id
8456: FROM wip_lpn_completions
8457: WHERE header_id = v_mo_line.reference_id
8458: AND lpn_id = p_lpn_id;
8459: ELSE
8460: l_completion_txn_id := NULL;