[Home] [Help]
936: * changes are being made to call this program only if the lpn_context is 2 or 3 */
937:
938: SELECT lpn_context
939: INTO l_lpn_context
940: FROM wms_license_plate_numbers
941: WHERE lpn_id = l_lpn_id;
942: IF l_lpn_context in (2,3) THEN
943: wms_putaway_suggestions.start_pregenerate_program(p_org_id =>i.organization_id,
944: p_lpn_id => l_lpn_id,
1146: , wlpnc.COST_GROUP_ID cg_id
1147: , rt.destination_type_code
1148: , rt.quantity rt_quantity
1149: , rt.parent_transaction_id
1150: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlpnc, rcv_transactions rt
1151: WHERE rt.group_id = p_group_id
1152: AND (((( rt.transaction_type = 'RETURN TO VENDOR'
1153: AND rt.lpn_id IS NOT NULL -- 3603808
1154: )
1589: -- Update the context for the pack lpn to 'resides in
1590: -- receiving' as packunpack api may have changed it to
1591: -- 'Defined but not used'
1592:
1593: UPDATE wms_license_plate_numbers
1594: SET lpn_context = wms_container_pub.lpn_context_rcv
1595: WHERE lpn_id = l_pack_lpn;
1596:
1597: ELSIF ((i.lpn_id IS NOT NULL OR i.transfer_lpn_id IS NOT NULL) AND
1708: -- update the lpn_context as while unpacking, the
1709: -- packunpack api might have changed the context
1710: -- to 'Defined But not used'
1711: IF (l_parent_transaction_type = 'RECEIVE') THEN
1712: UPDATE wms_license_plate_numbers
1713: SET lpn_context = wms_container_pub.lpn_context_rcv
1714: WHERE lpn_id = l_lpn_id;
1715: END IF;
1716:
2412:
2413: BEGIN
2414: SELECT lpn_context
2415: INTO l_lpn_context
2416: FROM wms_license_plate_numbers
2417: WHERE organization_id = p_org_id
2418: AND lpn_id = p_lpn_id;
2419: EXCEPTION
2420: WHEN no_data_found THEN
2653:
2654: l_lpn_update := NULL;
2655:
2656: -- Bug 4411792
2657: --UPDATE wms_license_plate_numbers
2658: --SET lpn_context = l_lpn_context
2659: --WHERE organization_id = p_org_id
2660: --AND lpn_id = p_lpn_id;
2661: END IF;
2927: , l_lpn_attr.attribute12
2928: , l_lpn_attr.attribute13
2929: , l_lpn_attr.attribute14
2930: , l_lpn_attr.attribute15
2931: FROM wms_license_plate_numbers
2932: WHERE lpn_id = l_lpn_id;
2933: EXCEPTION
2934: WHEN NO_DATA_FOUND THEN
2935: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
3081:
3082: BEGIN
3083:
3084: SELECT 1 INTO v_dummy
3085: FROM rcv_transactions_interface rti,wms_license_plate_numbers wlpn
3086: WHERE rti.interface_transaction_id = p_rcv_trx_interface_id
3087: AND rti.processing_status_code = 'WSH_INTERFACED'
3088: AND rti.transfer_lpn_id = wlpn.lpn_id
3089: AND wlpn.lpn_context = 5
3202: wlc.SECONDARY_QUANTITY sec_qty ,
3203: wlc.SECONDARY_UOM_CODE sec_uom ,
3204: wlc.SERIAL_SUMMARY_ENTRY serial_control
3205: FROM wms_lpn_contents wlc,
3206: wms_license_plate_numbers wlpn
3207: WHERE wlc.parent_lpn_id = wlpn.lpn_id
3208: AND wlpn.lpn_id = p_lpn_id
3209: AND wlc.source_header_id IS NULL ;
3210: l_unpack_rec c_unpack_lpn%ROWTYPE ;
3660: end if;
3661:
3662: END LOOP;
3663:
3664: UPDATE wms_license_plate_numbers
3665: SET lpn_context = wms_container_pub.lpn_context_rcv
3666: WHERE lpn_id = p_lpn_id;
3667:
3668: UPDATE mtl_txn_request_lines
4144: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4145: BEGIN
4146: OPEN x_lpn_lov FOR
4147: select distinct wlpnc.license_plate_number
4148: from wms_license_plate_numbers wlpnc, rcv_transactions_interface rti
4149: where rti.lpn_id = p_lpn_id
4150: and rti.item_id = p_item_id
4151: and nvl(rti.item_revision, '@@@') = nvl(p_revision, '@@@')
4152: and nvl(rti.transaction_type, '@@@') = 'RETURN TO RECEIVING'