DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_PO_REQ_LINES

Line 194: FROM JAI_PO_REQ_LINES

190: */
191:
192: CURSOR po_reqn_lines_count(p_requisition_number VARCHAR2) IS
193: SELECT count(1)
194: FROM JAI_PO_REQ_LINES
195: WHERE requisition_header_id IN ( SELECT requisition_header_id
196: FROM po_requisition_headers_all a, oe_order_headers_all b
197: WHERE A.segment1 = b.orig_sys_document_ref
198: AND A.segment1 = p_requisition_number );