APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_HEADERS_MERGE_V

Line 2042: FROM po_headers_merge_v

2038: SELECT DECODE(draft_id, -1, AUTHORIZATION_STATUS, STATUS),
2039: NVL(REVISION_NUM,0)
2040: INTO l_authorization_status,
2041: l_po_revision
2042: FROM po_headers_merge_v
2043: WHERE PO_HEADER_ID = l_document_id
2044: AND draft_id = l_draft_id;
2045: --Mod Project end
2046: /* Bug#1810322: kagarwal

Line 3209: FROM po_headers_merge_v

3205: -- CLM Aprvl Modifying the PO Cursor to use Merge Views
3206: CURSOR po_cursor(p_header_id NUMBER, p_draft_id NUMBER)
3207: IS
3208: SELECT wf_item_key
3209: FROM po_headers_merge_v
3210: WHERE po_header_id= p_header_id
3211: AND draft_id = p_draft_id;
3212: CURSOR req_cursor(p_header_id NUMBER)
3213: IS

Line 5430: FROM PO_HEADERS_MERGE_V

5426: INTO l_auth_stat,
5427: l_revision_num,
5428: l_transaction_type,
5429: l_draft_type
5430: FROM PO_HEADERS_MERGE_V
5431: WHERE po_header_id = p_doc_id
5432: AND draft_id = l_draft_id;
5433: END IF;
5434: --l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'AME_TRANSACTION_TYPE');

Line 8956: po_headers_merge_v phm

8952: INTO l_itemtype,
8953: l_workflow_process,
8954: l_ame_transaction_type
8955: FROM po_doc_style_headers ds,
8956: po_headers_merge_v phm
8957: WHERE phm.po_header_id = DocumentId
8958: AND NVL(phm.draft_id, -1) = DraftId
8959: AND phm.style_id = ds.style_id
8960: AND ds.wf_approval_itemtype IS NOT NULL