DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on PO_REQUISITION_LINES_ALL

Line 250: AND ((p_req_header_id is null) or EXISTS ( select 1 from po_requisition_lines_all prla where

246: AND rsl.item_id = p_item_id
247: AND msn.inventory_item_id = p_item_id
248: AND msn.serial_number = rss.serial_num
249: AND msn.current_status = 5
250: AND ((p_req_header_id is null) or EXISTS ( select 1 from po_requisition_lines_all prla where
251: prla.requisition_header_id = p_req_header_id
252: AND rsl.requisition_line_id = prla.requisition_line_id ) )--14722067 new
253: AND Nvl(msn.lpn_id,NVL(p_from_lpn_id,-1)) = NVL(p_from_lpn_id, NVL(msn.lpn_id, -1))
254: AND ( (l_rcv_org_lot_ctrl = 1 OR l_src_org_lot_ctrl = 1) OR