APPS.ICX_CAT_R12_DATA_EXCEP_RPT_PVT dependencies on PO_HEADERS_INTERFACE

Line 148: PROCEDURE process_data_exceptions_report(p_batch_id IN po_headers_interface.batch_id%TYPE)

144: ** Synopsis : Populates the exceptions file table
145: **
146: ** Parameter: p_batch_id--Batch_id
147: **/
148: PROCEDURE process_data_exceptions_report(p_batch_id IN po_headers_interface.batch_id%TYPE)
149: IS
150:
151: --Cursor fetching data from po_headers_interface
152: CURSOR interface_headers_cursor(p_batch_id NUMBER) IS

Line 151: --Cursor fetching data from po_headers_interface

147: **/
148: PROCEDURE process_data_exceptions_report(p_batch_id IN po_headers_interface.batch_id%TYPE)
149: IS
150:
151: --Cursor fetching data from po_headers_interface
152: CURSOR interface_headers_cursor(p_batch_id NUMBER) IS
153: SELECT distinct pohi.interface_header_id,
154: pohi.vendor_id,
155: pohi.vendor_site_id,

Line 160: FROM po_headers_interface pohi,

156: pohi.org_id,
157: pohi.currency_code,
158: pohi.cpa_reference,
159: poai.language
160: FROM po_headers_interface pohi,
161: po_attr_values_tlp_interface poai
162: WHERE pohi.batch_id = p_batch_id
163: AND poai.interface_header_id = pohi.interface_header_id
164: AND EXISTS (SELECT 1

Line 681: FROM po_headers_interface pohi, HR_ALL_ORGANIZATION_UNITS hro,

677: XMLElement("SUPPLIER_NAME", pv.vendor_name),
678: XMLElement("SUPPLIER_SITE", pvs.vendor_site_Code),
679: XMLElement("CURRENCY", pohi.currency_code)),
680: XMLElement("LINES", ''R12_ITEM_DET'')))) AS CATALOG
681: FROM po_headers_interface pohi, HR_ALL_ORGANIZATION_UNITS hro,
682: po_vendors pv, po_vendor_sites_all pvs
683: WHERE pohi.interface_header_id = :INTERFACE_HEADER_ID
684: AND pohi.org_id = hro.organization_id (+)
685: AND pohi.vendor_id = pv.vendor_id (+)