APPS.INV_UI_PROJECT_LOVS dependencies on STANDARD

Line 155: AND poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

151: AND pod.po_line_id = poll.po_line_id
152: AND Nvl(pod.po_release_id,-999) = Nvl(poll.po_release_id,-999)
153: AND pod.po_header_id = poll.po_header_id
154: AND Nvl(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
155: AND poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
156: AND NVL(poll.APPROVED_FLAG,'N') = 'Y'
157: AND NVL(poll.CANCEL_FLAG, 'N') = 'N'
158: AND p.project_number LIKE ( p_project_number )
159: AND pod.project_id IS NOT NULL ;

Line 185: AND poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

181: AND pod.po_line_id = poll.po_line_id
182: AND Nvl(pod.po_release_id,-999) = Nvl(poll.po_release_id,-999)
183: AND pod.po_header_id = poll.po_header_id
184: AND Nvl(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
185: AND poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
186: AND NVL(poll.APPROVED_FLAG,'N') = 'Y'
187: AND NVL(poll.CANCEL_FLAG, 'N') = 'N'
188: AND p.project_number LIKE ( p_project_number )
189: AND pod.project_id IS NOT NULL

Line 210: AND poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

206: AND pod.po_line_id = poll.po_line_id
207: AND Nvl(pod.po_release_id,-999) = Nvl(poll.po_release_id,-999)
208: AND pod.po_header_id = poll.po_header_id
209: AND Nvl(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
210: AND poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
211: AND NVL(poll.APPROVED_FLAG,'N') = 'Y'
212: AND NVL(poll.CANCEL_FLAG, 'N') = 'N'
213: AND l_no_proj_str LIKE ( p_project_number ) ;
214: END IF;