APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_HEADERS_ALL

Line 4690: FROM PO_HEADERS_ALL POH

4686: AND (POLI.interface_header_id IS NULL OR
4687: (POLI.po_header_id IS NOT NULL AND
4688: NOT EXISTS
4689: (SELECT 'PO_HEADER_ID points to valid doc'
4690: FROM PO_HEADERS_ALL POH
4691: WHERE POH.po_header_id = POLI.po_header_id)))
4692: RETURNING POLI.interface_line_id, POLI.interface_header_id
4693: BULK COLLECT INTO l_err_line_ids, l_err_header_ids;
4694:

Line 4880: FROM PO_HEADERS_ALL POH

4876: AND POHI.action = 'UPDATE'
4877: AND (POHI.po_header_id is null
4878: OR NOT EXISTS
4879: (SELECT 'document exists'
4880: FROM PO_HEADERS_ALL POH
4881: WHERE POH.po_header_id = POHI.po_header_id))
4882: RETURNING POHI.interface_header_id
4883: BULK COLLECT INTO l_err_header_ids;
4884:

Line 5218: FROM PO_HEADERS_ALL POH

5214: AND POHI.action = 'DELETE'
5215: AND (POHI.po_header_id is null
5216: OR EXISTS
5217: (SELECT 'document not created by migration program'
5218: FROM PO_HEADERS_ALL POH
5219: WHERE POH.po_header_id = POHI.po_header_id
5220: AND POH.created_by <> PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER))
5221: RETURNING POHI.interface_header_id
5222: BULK COLLECT INTO l_err_header_ids;

Line 5434: PO_HEADERS_ALL POH

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))
5438: -- For ReqTemplates, you can not delete TLP row for base_language