APPS.PO_DRAFTS_PVT dependencies on PO_LINES_MERGE_V

Line 2558: ELSIF (p_view_name = 'PO_LINES_MERGE_V') THEN

2554: PO_HEADERS_DRAFT_PKG.lock_transaction_record
2555: ( p_po_header_id => p_entity_id
2556: );
2557:
2558: ELSIF (p_view_name = 'PO_LINES_MERGE_V') THEN
2559: d_position := 20;
2560:
2561: PO_LINES_DRAFT_PKG.lock_draft_record
2562: ( p_po_line_id => p_entity_id,

Line 8900: FROM po_lines_merge_v

8896:
8897: --Delete extra PRICING attribute record from po_lines_all_ext_b
8898: DELETE FROM po_lines_all_ext_b ple
8899: where ( Abs(ple.po_line_id), Abs(ple.draft_id) ) IN ( SELECT po_line_id, Decode(draft_id,-1,1,draft_id)
8900: FROM po_lines_merge_v
8901: WHERE po_header_id = p_po_header_id
8902: AND draft_id = p_draft_id
8903: )
8904: AND EXISTS ( SELECT 1

Line 8905: FROM po_lines_merge_v plm , po_uda_ag_template_usages ptu

8901: WHERE po_header_id = p_po_header_id
8902: AND draft_id = p_draft_id
8903: )
8904: AND EXISTS ( SELECT 1
8905: FROM po_lines_merge_v plm , po_uda_ag_template_usages ptu
8906: WHERE plm.po_line_id = Abs(ple.po_line_id)
8907: AND plm.draft_id = Decode(p_draft_id,
8908: -1,-1,
8909: Abs(ple.draft_id))

Line 8928: FROM po_lines_merge_v

8924: d_position := 10;
8925: --Delete extra PRICING attribute record from po_lines_all_ext_tl
8926: DELETE FROM po_lines_all_ext_tl ple
8927: where ( Abs(ple.po_line_id), Abs(ple.draft_id) ) IN ( SELECT po_line_id, Decode(draft_id,-1,1,draft_id)
8928: FROM po_lines_merge_v
8929: WHERE po_header_id = p_po_header_id
8930: AND draft_id = p_draft_id
8931: )
8932:

Line 8934: FROM po_lines_merge_v plm , po_uda_ag_template_usages ptu

8930: AND draft_id = p_draft_id
8931: )
8932:
8933: AND EXISTS ( SELECT 1
8934: FROM po_lines_merge_v plm , po_uda_ag_template_usages ptu
8935: WHERE plm.po_line_id = Abs(ple.po_line_id)
8936: AND plm.draft_id = Decode(p_draft_id,
8937: -1,-1,
8938: Abs(ple.draft_id))

Line 9188: po_lines_merge_v pl

9184: clm_exhibit_name_tbl,
9185: po_header_id_tbl,
9186: po_draft_id_tbl
9187: FROM
9188: po_lines_merge_v pl
9189: WHERE pl.clm_exhibit_name IS NOT NULL
9190: AND pl.po_header_id = p_po_header_id
9191: AND pl.draft_id = p_draft_id
9192: AND Nvl(pl.delete_flag,'N') <> 'Y'

Line 9421: FROM po_lines_merge_v

9417: Nvl(po_core_s.Retrieveoptionvalue(org_id, po_core_s.g_undef_cont_act_col),
9418: 'N'
9419: )
9420: INTO l_isucaenabled
9421: FROM po_lines_merge_v
9422: WHERE po_line_id = po_line_ids_tbl(1)
9423: AND draft_id = p_po_draft_id;
9424: END IF;
9425: