APPS.ICX_CAT_POPULATE_REQTMPL_PVT dependencies on ICX_CAT_ITEMS_CTX_HDRS_TLP

Line 132: icx_cat_items_ctx_hdrs_tlp ctx

128: AND po_tlp.language = ic.language (+)
129: AND prl.suggested_vendor_id = pv.vendor_id(+)
130: AND prl.rowid BETWEEN g_start_rowid and g_end_rowid
131: ) doc,
132: icx_cat_items_ctx_hdrs_tlp ctx
133: WHERE -2 = ctx.po_line_id (+)
134: AND doc.inventory_item_id=ctx.inventory_item_id(+)
135: AND doc.req_template_name = ctx.req_template_name (+)
136: AND doc.req_template_line_num = ctx.req_template_line_num (+)

Line 238: icx_cat_items_ctx_hdrs_tlp ctx

234: OR prh.last_update_date > g_upgrade_last_run_date
235: OR prl.last_update_date > g_upgrade_last_run_date
236: OR po_tlp.last_update_date > g_upgrade_last_run_date)
237: ) doc,
238: icx_cat_items_ctx_hdrs_tlp ctx
239: WHERE -2 = ctx.po_line_id (+)
240: AND doc.inventory_item_id=ctx.inventory_item_id(+)
241: AND doc.req_template_name = ctx.req_template_name (+)
242: AND doc.req_template_line_num = ctx.req_template_line_num (+)

Line 378: icx_cat_items_ctx_hdrs_tlp ctx

374: AND po_tlp.ip_category_id = ic.rt_category_id (+)
375: AND po_tlp.language = ic.language (+)
376: AND prl.suggested_vendor_id = pv.vendor_id(+)
377: ) doc,
378: icx_cat_items_ctx_hdrs_tlp ctx
379: WHERE -2 = ctx.po_line_id (+)
380: AND doc.inventory_item_id=ctx.inventory_item_id(+)
381: AND doc.req_template_name = ctx.req_template_name (+)
382: AND doc.req_template_line_num = ctx.req_template_line_num (+)