DBA Data[Home] [Help]

APPS.PO_DRAFTS_PVT dependencies on PO_HEADERS_MERGE_V

Line 2546: IF (p_view_name = 'PO_HEADERS_MERGE_V') THEN

2542: IF (PO_LOG.d_proc) THEN
2543: PO_LOG.proc_begin(d_module);
2544: END IF;
2545:
2546: IF (p_view_name = 'PO_HEADERS_MERGE_V') THEN
2547: d_position := 10;
2548:
2549: PO_HEADERS_DRAFT_PKG.lock_draft_record
2550: ( p_po_header_id => p_entity_id,

Line 8959: FROM po_headers_merge_v phm , po_uda_ag_template_usages ptu

8955: where phe.po_header_id = p_po_header_id
8956: AND Nvl(phe.draft_id,-1) = p_draft_id
8957:
8958: AND EXISTS ( SELECT 1
8959: FROM po_headers_merge_v phm , po_uda_ag_template_usages ptu
8960: WHERE phm.po_header_id = phe.po_header_id
8961: AND phm.draft_id = Nvl(phe.draft_id,-1)
8962: AND ptu.attribute_category = 'FORMS'
8963: AND ptu.template_id = phm.uda_template_id

Line 8979: FROM po_headers_merge_v phm , po_uda_ag_template_usages ptu

8975: where phe.po_header_id = p_po_header_id
8976: AND Nvl(phe.draft_id,-1) = p_draft_id
8977:
8978: AND EXISTS ( SELECT 1
8979: FROM po_headers_merge_v phm , po_uda_ag_template_usages ptu
8980: WHERE phm.po_header_id = phe.po_header_id
8981: AND phm.draft_id = Nvl(phe.draft_id,-1)
8982: AND ptu.attribute_category = 'FORMS'
8983: AND ptu.template_id = phm.uda_template_id