APPS.PO_SIGNATURE_PVT dependencies on PO_HEADERS_MERGE_V

Line 229: -- CLM Apprvl: Modified the table from po_headers_all to po_headers_merge_v and included draft_id check

225: -- category CONTRACT. See Bug 3897511.
226: -- : Signature notification should show the PDF document
227: -- for PO without contract terms as well
228:
229: -- CLM Apprvl: Modified the table from po_headers_all to po_headers_merge_v and included draft_id check
230:
231: BEGIN
232: SELECT NVL(poh.conterms_exist_flag,'N')
233: INTO l_conterms_exist

Line 234: FROM po_headers_merge_v poh

230:
231: BEGIN
232: SELECT NVL(poh.conterms_exist_flag,'N')
233: INTO l_conterms_exist
234: FROM po_headers_merge_v poh
235: WHERE poh.po_header_id = l_document_id
236: AND poh.draft_id = l_draft_id;
237: EXCEPTION
238: WHEN others THEN

Line 281: po_headers_merge_v phm,

277: BEGIN
278: SELECT fu.user_name
279: INTO l_supplier_user_name
280: FROM po_supplier_contacts_val_v pscv,
281: po_headers_merge_v phm,
282: fnd_user fu
283: WHERE pscv.vendor_contact_id = phm.vendor_contact_id
284: AND pscv.vendor_site_id = phm.vendor_site_id
285: AND fu.user_name = pscv.user_name

Line 1139: po_headers_merge_v poh

1135:
1136: select nvl(clm_flag,'N')
1137: into l_is_clm_enabled
1138: from po_doc_style_headers psh,
1139: po_headers_merge_v poh
1140: where psh.style_id = poh.style_id
1141: and poh.po_header_id = l_document_id
1142: and poh.draft_id = l_draft_id;
1143: EXCEPTION

Line 1149: -- CLM Apprvl start - querying the item type and item key from po_headers_merge_v instead of the base table

1145: l_is_clm_enabled := 'N';
1146: END;
1147: /* end bug9924585 */
1148:
1149: -- CLM Apprvl start - querying the item type and item key from po_headers_merge_v instead of the base table
1150:
1151: if l_draft_id <> -1 then
1152: SELECT wf_item_type,
1153: wf_item_key

Line 1156: FROM PO_HEADERS_MERGE_V

1152: SELECT wf_item_type,
1153: wf_item_key
1154: INTO l_po_itemtype,
1155: l_po_itemkey
1156: FROM PO_HEADERS_MERGE_V
1157: WHERE po_header_id = l_document_id
1158: AND draft_id = l_draft_id;
1159: else
1160: SELECT wf_item_type,

Line 2517: FROM po_headers_merge_v

2513: -- CLM Apprvl. the CLM modifications have a draft_id and for POs the draft_id is null
2514: IF ( l_document_type <> 'RELEASE' ) THEN
2515: SELECT acceptance_required_flag
2516: INTO l_acceptance_flag
2517: FROM po_headers_merge_v
2518: WHERE po_header_id = l_document_id
2519: AND draft_id = l_draft_id;
2520:
2521: END IF;

Line 4459: FROM po_headers_merge_v

4455: IF ( l_document_type <> 'RELEASE' ) THEN
4456: IF l_draft_id IS NOT NULL AND l_draft_id <> -1 THEN
4457: SELECT acceptance_required_flag
4458: INTO l_acceptance_flag
4459: FROM po_headers_merge_v
4460: WHERE po_header_id = l_document_id
4461: AND draft_id = l_draft_id;
4462: ELSE
4463: SELECT acceptance_required_flag

Line 4465: FROM po_headers_merge_v

4461: AND draft_id = l_draft_id;
4462: ELSE
4463: SELECT acceptance_required_flag
4464: INTO l_acceptance_flag
4465: FROM po_headers_merge_v
4466: WHERE po_header_id = l_document_id;
4467: END IF;
4468: END IF;
4469: