APPS.ICX_ITEM_DIAG_PVT dependencies on PO_LINES_ALL

Line 1908: where po_header_id in ( select distinct pol.po_header_id from po_attribute_values_tlp po , icx_cat_items_ctx_hdrs_tlp ctx, po_lines_all pol

1904: if p_source_type = 'BLANKET' then
1905: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,p_source_type);
1906:
1907: update po_headers_all set last_update_date = sysdate
1908: where po_header_id in ( select distinct pol.po_header_id from po_attribute_values_tlp po , icx_cat_items_ctx_hdrs_tlp ctx, po_lines_all pol
1909: where po.po_line_id=ctx.po_line_id
1910: and po.po_line_id=pol.po_line_id
1911: and ctx.source_type in ('BLANKET','QUOTATION','GLOBAL_BLANKET')
1912: and (po.ip_category_id <> ctx.ip_category_id or pol.unit_price <> ctx.unit_price)