DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on PO_LINES_ALL

Line 4401: po_lines_all pl, po_headers_all ph

4397: AND (
4398: -- Req template lines that are invalid.
4399: EXISTS ( SELECT 'x'
4400: FROM po_reqexpress_lines_all prl, po_reqexpress_headers_all prh,
4401: po_lines_all pl, po_headers_all ph
4402: WHERE hdrs.po_line_id = -2
4403: AND hdrs.inventory_item_id = nvl(prl.item_id, -2)
4404: AND hdrs.req_template_name = prl.express_name
4405: AND hdrs.req_template_line_num = prl.sequence_num

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

4547: -- Quote lines that are invalid.
4548: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus(hdrs.po_line_id) = -1
4549: OR
4550: -- Quote lines that are deleted.
4551: NOT EXISTS ( SELECT 'x' FROM po_lines_all pl
4552: WHERE hdrs.po_line_id = pl.po_line_id)
4553: )
4554: AND ROWNUM <= ICX_CAT_UTIL_PVT.g_batch_size
4555: RETURNING po_line_id, req_template_name, req_template_line_num,

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

4673:
4674: l_err_loc := 300;
4675: DELETE FROM icx_cat_items_ctx_hdrs_tlp hdrs
4676: WHERE hdrs.source_type IN ('BLANKET', 'GLOBAL_BLANKET')
4677: AND EXISTS ( SELECT 'x' FROM po_lines_all pl, po_headers_all ph
4678: WHERE hdrs.po_line_id = pl.po_line_id
4679: AND pl.po_header_id = ph.po_header_id
4680: AND (ph.approved_date IS NULL
4681: OR NVL(ph.authorization_status, 'INCOMPLETE') IN ('REJECTED', 'INCOMPLETE')