APPS.WMS_RETURN_SV dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 940: FROM wms_license_plate_numbers

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,

Line 1131: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlpnc, rcv_transactions rt

1127: , wlpnc.COST_GROUP_ID cg_id
1128: , rt.destination_type_code
1129: , rt.quantity rt_quantity
1130: , rt.parent_transaction_id
1131: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlpnc, rcv_transactions rt
1132: WHERE rt.group_id = p_group_id
1133: AND (((( rt.transaction_type = 'RETURN TO VENDOR'
1134: AND rt.lpn_id IS NOT NULL -- 3603808
1135: )

Line 1574: UPDATE wms_license_plate_numbers

1570: -- Update the context for the pack lpn to 'resides in
1571: -- receiving' as packunpack api may have changed it to
1572: -- 'Defined but not used'
1573:
1574: UPDATE wms_license_plate_numbers
1575: SET lpn_context = wms_container_pub.lpn_context_rcv
1576: WHERE lpn_id = l_pack_lpn;
1577:
1578: ELSIF ((i.lpn_id IS NOT NULL OR i.transfer_lpn_id IS NOT NULL) AND

Line 1693: UPDATE wms_license_plate_numbers

1689: -- update the lpn_context as while unpacking, the
1690: -- packunpack api might have changed the context
1691: -- to 'Defined But not used'
1692: IF (l_parent_transaction_type = 'RECEIVE') THEN
1693: UPDATE wms_license_plate_numbers
1694: SET lpn_context = wms_container_pub.lpn_context_rcv
1695: WHERE lpn_id = l_lpn_id;
1696: END IF;
1697:

Line 2363: FROM wms_license_plate_numbers

2359:
2360: BEGIN
2361: SELECT lpn_context
2362: INTO l_lpn_context
2363: FROM wms_license_plate_numbers
2364: WHERE organization_id = p_org_id
2365: AND lpn_id = p_lpn_id;
2366: EXCEPTION
2367: WHEN no_data_found THEN

Line 2558: --UPDATE wms_license_plate_numbers

2554:
2555: l_lpn_update := NULL;
2556:
2557: -- Bug 4411792
2558: --UPDATE wms_license_plate_numbers
2559: --SET lpn_context = l_lpn_context
2560: --WHERE organization_id = p_org_id
2561: --AND lpn_id = p_lpn_id;
2562: END IF;

Line 2752: UPDATE wms_license_plate_numbers

2748: end if;
2749:
2750: END LOOP;
2751:
2752: UPDATE wms_license_plate_numbers
2753: SET lpn_context = wms_container_pub.lpn_context_rcv
2754: WHERE lpn_id = p_lpn_id;
2755:
2756: UPDATE mtl_txn_request_lines

Line 3236: from wms_license_plate_numbers wlpnc, rcv_transactions_interface rti

3232: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3233: BEGIN
3234: OPEN x_lpn_lov FOR
3235: select distinct wlpnc.license_plate_number
3236: from wms_license_plate_numbers wlpnc, rcv_transactions_interface rti
3237: where rti.lpn_id = p_lpn_id
3238: and rti.item_id = p_item_id
3239: and nvl(rti.item_revision, '@@@') = nvl(p_revision, '@@@')
3240: and nvl(rti.transaction_type, '@@@') = 'RETURN TO RECEIVING'