APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_LINES_ALL

Line 4927: FROM PO_LINES_ALL POL

4923: AND POLI.action = 'UPDATE'
4924: AND (POLI.po_line_id is null
4925: OR NOT EXISTS
4926: (SELECT 'line exists'
4927: FROM PO_LINES_ALL POL
4928: WHERE POL.po_line_id = POLI.po_line_id))
4929: RETURNING POLI.interface_line_id, POLI.interface_header_id
4930: BULK COLLECT INTO l_err_line_ids, l_err_header_ids;
4931:

Line 5266: FROM PO_LINES_ALL POL

5262: AND POLI.action = 'DELETE'
5263: AND (POLI.po_line_id is null
5264: OR EXISTS
5265: (SELECT 'line not created by migration program'
5266: FROM PO_LINES_ALL POL
5267: WHERE POL.po_line_id = POLI.po_line_id
5268: AND POL.created_by <> PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER))
5269: RETURNING POLI.interface_line_id, POLI.interface_header_id
5270: BULK COLLECT INTO l_err_line_ids, l_err_header_ids;

Line 5433: FROM PO_LINES_ALL POL,

5429: -- For GBPA/BPA/Quotations, you can not delete TLP row for created_language
5430: OR (POATI.po_line_id <> g_NOT_REQUIRED_ID
5431: AND EXISTS
5432: (SELECT 'TLP row for deletion is specified for created_lang'
5433: FROM PO_LINES_ALL POL,
5434: PO_HEADERS_ALL POH
5435: WHERE POL.po_line_id = POATI.po_line_id
5436: AND POH.po_header_id = POL.po_header_id
5437: AND POH.created_language = POATI.language))