DBA Data[Home] [Help]

APPS.ICX_CAT_R12_DATA_EXCEP_RPT_PVT dependencies on PO_ATTR_VALUES_TLP_INTERFACE

Line 161: po_attr_values_tlp_interface poai

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
165: FROM po_interface_errors poie

Line 367: FROM po_attr_values_tlp_interface poai

363: WHERE poie.interface_header_id = poli.interface_header_id
364: AND (poie.interface_line_id IS NULL OR
365: poie.interface_line_id = poli.interface_line_id))
366: AND EXISTS (SELECT 1
367: FROM po_attr_values_tlp_interface poai
368: WHERE poai.interface_header_id = poli.interface_header_id
369: AND poai.interface_line_id = poli.interface_line_id
370: AND poai.language = p_language);
371:

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