DBA Data[Home] [Help]

APPS.ICX_CAT_R12_DATA_EXCEP_RPT_PVT dependencies on PO_LINES_INTERFACE

Line 359: FROM po_lines_interface poli

355: -- interface errors and attr values tlp tables.
356: Cursor category_ids_cursor(p_interface_header_id number,
357: p_language varchar2) is
358: SELECT distinct poli.ip_category_id
359: FROM po_lines_interface poli
360: WHERE poli.interface_header_id = p_interface_header_id
361: AND EXISTS (SELECT 1
362: FROM po_interface_errors poie
363: WHERE poie.interface_header_id = poli.interface_header_id

Line 824: FROM po_lines_interface poli, po_attr_values_tlp_interface poavti, po_attr_values_interface poavi

820: XMLAttributes(nvl(poli.negotiated_by_preparer_flag, '' '') as "negotiated"),
821: XMLElement("UNIT_PRICE", poli.unit_price),
822: XMLElement("UNIT_OF_MEASURE", poli.uom_code)
823: ))) AS ITEMS_INF
824: FROM po_lines_interface poli, po_attr_values_tlp_interface poavti, po_attr_values_interface poavi
825: WHERE poli.interface_header_id = :INTERFACE_HEADER_ID
826: AND poli.ip_category_id = :IP_CATEGORY_ID
827: AND poavi.interface_header_id = poli.interface_header_id
828: AND poavi.interface_line_id = poli.interface_line_id