DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on STANDARD

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

178: AND pod.po_line_id = poll.po_line_id
179: AND Nvl(pod.po_release_id,-999) = Nvl(poll.po_release_id,-999)
180: AND pod.po_header_id = poll.po_header_id
181: AND Nvl(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
182: AND poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
183: AND NVL(poll.APPROVED_FLAG,'N') = 'Y'
184: AND NVL(poll.CANCEL_FLAG, 'N') = 'N'
185: AND t.task_number LIKE ( p_task_number );
186: END;