APPS.INV_RCV_DIR_RCPT_APIS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 3998: UPDATE wms_license_plate_numbers

3994: -- Nested LPN changes
3995: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3996: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3997: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3998: UPDATE wms_license_plate_numbers
3999: SET lpn_context = 3
4000: WHERE lpn_id = p_lpn_id;
4001: END IF;
4002:

Line 4161: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh

4157: , wlpnc.lot_number
4158: , wlpnc.source_line_id
4159: , wlpn.organization_id lpn_org_id
4160: , wlpnc.secondary_quantity --Bug 7656734
4161: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh
4162: WHERE rsh.shipment_header_id = p_shipment_header_id
4163: AND (wlpn.source_header_id = rsh.shipment_header_id
4164: OR wlpn.source_name = rsh.shipment_num)
4165: AND wlpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones

Line 4173: FROM wms_license_plate_numbers

4169: -- LPN id will be NULL, In this case we should not expand the LPN
4170: -- in which case start with lpn_id = p_lpn_id will fail.
4171: AND (wlpnc.parent_lpn_id = NVL(p_lpn_id, wlpn.lpn_id)
4172: OR wlpnc.parent_lpn_id IN(SELECT lpn_id
4173: FROM wms_license_plate_numbers
4174: START WITH lpn_id = p_lpn_id
4175: CONNECT BY parent_lpn_id = PRIOR lpn_id))
4176: AND wlpnc.inventory_item_id = msi.inventory_item_id
4177: AND msi.organization_id = p_organization_id

Line 4861: UPDATE wms_license_plate_numbers

4857: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4858: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4859: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4860:
4861: UPDATE wms_license_plate_numbers
4862: SET lpn_context = 3
4863: WHERE source_header_id = p_shipment_header_id
4864: AND lpn_id = NVL(p_lpn_id, lpn_id);
4865:

Line 4886: FROM wms_license_plate_numbers

4882: SET source_name = 'ASNEXP'
4883: , source_header_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4884: WHERE lpn_context = 7
4885: AND parent_lpn_id IN(SELECT lpn_id
4886: FROM wms_license_plate_numbers
4887: WHERE source_header_id = p_shipment_header_id
4888: AND lpn_id = NVL(p_lpn_id, lpn_id));
4889: END IF;
4890: