APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on PO_LINES_ALL

Line 4426: po_lines_all pl, po_headers_all ph

4422: AND (
4423: -- Req template lines that are invalid.
4424: EXISTS ( SELECT 'x'
4425: FROM po_reqexpress_lines_all prl, po_reqexpress_headers_all prh,
4426: po_lines_all pl, po_headers_all ph
4427: WHERE hdrs.po_line_id = -2
4428: AND hdrs.inventory_item_id = nvl(prl.item_id, -2)
4429: AND hdrs.req_template_name = prl.express_name
4430: AND hdrs.req_template_line_num = prl.sequence_num

Line 4576: NOT EXISTS ( SELECT 'x' FROM po_lines_all pl

4572: -- Quote lines that are invalid.
4573: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus(hdrs.po_line_id) = -1
4574: OR
4575: -- Quote lines that are deleted.
4576: NOT EXISTS ( SELECT 'x' FROM po_lines_all pl
4577: WHERE hdrs.po_line_id = pl.po_line_id)
4578: )
4579: AND ROWNUM <= ICX_CAT_UTIL_PVT.g_batch_size
4580: RETURNING po_line_id, req_template_name, req_template_line_num,

Line 4702: AND EXISTS ( SELECT 'x' FROM po_lines_all pl, po_headers_all ph

4698:
4699: l_err_loc := 300;
4700: DELETE FROM icx_cat_items_ctx_hdrs_tlp hdrs
4701: WHERE hdrs.source_type IN ('BLANKET', 'GLOBAL_BLANKET')
4702: AND EXISTS ( SELECT 'x' FROM po_lines_all pl, po_headers_all ph
4703: WHERE hdrs.po_line_id = pl.po_line_id
4704: AND pl.po_header_id = ph.po_header_id
4705: AND (ph.approved_date IS NULL
4706: OR NVL(ph.authorization_status, 'INCOMPLETE') IN ('REJECTED', 'INCOMPLETE')