[Home] [Help]
20: AND ((current_organization_id = p_organization_id
21: AND current_status = 1
22: )
23: OR (current_status = 4 AND
24: Nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2
25: )
26: -- Bug# 12556104 ASN Std receipt, add serial status = 5 (Resides in intransit)
27: -- and check existence in rcv_serials_supply join to rcv_shipment_lines
28: -- and rcv_shipment_headers to ensure the serials belongs to the ASN
294: AND ( ( msn.current_status IN (1, 6)
295: AND msn.current_organization_id = p_organization_id
296: ) OR
297: ( msn.current_status = 4
298: AND nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2
299: ) )
300: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
301: AND rsl.to_organization_id = p_organization_id
302: AND rsl.item_id = p_item_id
401: l_wms_installed VARCHAR2(10) := 'FALSE';
402: l_number NUMBER;
403: l_global_profile VARCHAR2(1) := 'N'; --Global Lot ER
404: BEGIN
405: l_global_profile := NVL(FND_PROFILE.VALUE('INV_GLOBAL_LOT_ATTRIBUTES'),'N');--Global Lot ER
406:
407: x_expiration_date := '';
408: x_lot_status := '';
409:
3992: p_from_lpn_id IN NUMBER DEFAULT NULL)
3993:
3994: IS
3995:
3996: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3997:
3998: BEGIN
3999:
4000:
4022: AND ((current_organization_id = p_organization_id
4023: AND current_status = 1
4024: )
4025: OR (current_status = 4 AND
4026: Nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2)
4027: )
4028: AND msn.status_id = mms.status_id(+)
4029: AND mms.language (+) = userenv('LANG')
4030: AND serial_number LIKE (p_serial)