APPS.INV_RCV_DIR_RCPT_APIS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 3858: UPDATE wms_license_plate_numbers

3854: -- Nested LPN changes
3855: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3856: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3857: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3858: UPDATE wms_license_plate_numbers
3859: SET lpn_context = 3
3860: WHERE lpn_id = p_lpn_id;
3861: END IF;
3862:

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

4015: , wlpnc.uom_code
4016: , wlpnc.lot_number
4017: , wlpnc.source_line_id
4018: , wlpn.organization_id lpn_org_id
4019: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh
4020: WHERE rsh.shipment_header_id = p_shipment_header_id
4021: AND (wlpn.source_header_id = rsh.shipment_header_id
4022: OR wlpn.source_name = rsh.shipment_num)
4023: AND wlpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones

Line 4031: FROM wms_license_plate_numbers

4027: -- LPN id will be NULL, In this case we should not expand the LPN
4028: -- in which case start with lpn_id = p_lpn_id will fail.
4029: AND (wlpnc.parent_lpn_id = NVL(p_lpn_id, wlpn.lpn_id)
4030: OR wlpnc.parent_lpn_id IN(SELECT lpn_id
4031: FROM wms_license_plate_numbers
4032: START WITH lpn_id = p_lpn_id
4033: CONNECT BY parent_lpn_id = PRIOR lpn_id))
4034: AND wlpnc.inventory_item_id = msi.inventory_item_id
4035: AND msi.organization_id = p_organization_id

Line 4716: UPDATE wms_license_plate_numbers

4712: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4713: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4714: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4715:
4716: UPDATE wms_license_plate_numbers
4717: SET lpn_context = 3
4718: WHERE source_header_id = p_shipment_header_id
4719: AND lpn_id = NVL(p_lpn_id, lpn_id);
4720:

Line 4741: FROM wms_license_plate_numbers

4737: SET source_name = 'ASNEXP'
4738: , source_header_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4739: WHERE lpn_context = 7
4740: AND parent_lpn_id IN(SELECT lpn_id
4741: FROM wms_license_plate_numbers
4742: WHERE source_header_id = p_shipment_header_id
4743: AND lpn_id = NVL(p_lpn_id, lpn_id));
4744: END IF;
4745: