APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_LINES_MERGE_V

Line 1210: FROM po_lines_merge_v pla, po_line_types plt

1206:
1207: CURSOR c_line_attach
1208: IS
1209: SELECT plt.purchase_basis, pla.po_line_id, pla.line_num
1210: FROM po_lines_merge_v pla, po_line_types plt
1211: WHERE pla.po_header_id = po_autocreate_params.g_po_header_id
1212: AND pla.draft_id = l_draft_id
1213: AND plt.line_type_id(+) = pla.line_type_id
1214: AND EXISTS (

Line 1933: FROM po_lines_merge_v

1929: END IF;
1930:
1931: SELECT NVL(MAX(clm_option_num), 0)
1932: INTO l_next_option_num
1933: FROM po_lines_merge_v
1934: WHERE clm_base_line_num = l_rec.clm_base_line_num
1935: AND draft_id = l_draft_id
1936: ;
1937:

Line 2575: from po_lines_merge_v

2571:
2572: BEGIN
2573: select max(line_num)
2574: into l_max_line_num
2575: from po_lines_merge_v
2576: where po_header_id = p_po_header_id
2577: and draft_id = p_draft_id;
2578:
2579: EXCEPTION

Line 2595: from po_lines_merge_v

2591: l_progress := '020';
2592: BEGIN
2593: select line_num_display
2594: into l_clin_line_num_display
2595: from po_lines_merge_v
2596: where po_line_id = p_po_line_id
2597: and draft_id = p_draft_id;
2598:
2599: EXCEPTION

Line 2751: FROM po_lines_merge_v polm

2747: BEGIN
2748:
2749: SELECT 'Y'
2750: INTO l_is_convert_valid
2751: FROM po_lines_merge_v polm
2752: WHERE polm.po_line_id = p_po_line_id_tbl(i)
2753: AND polm.draft_id = p_draft_id_tbl(i)
2754: AND polm.group_line_id IS NULL
2755: AND NVL(polm.clm_info_flag,'N') <> 'Y'

Line 2872: ,(SELECT po_line_id FROM po_lines_merge_v

2868: ,EXHIBIT_NUMBER --EXHIBIT_NAME
2869: ,EXHIBIT_DESCRIPTION --EXHIBIT_DESCRIPTION
2870: ,IS_CDRL --IS_CDRL
2871: ,po_autocreate_params.g_po_header_id --PO_HEADER_ID
2872: ,(SELECT po_line_id FROM po_lines_merge_v
2873: WHERE po_header_id = po_autocreate_params.g_po_header_id
2874: AND AUCTION_LINE_NUMBER = paed.associated_to_line
2875: AND draft_id = Nvl(po_autocreate_params.g_draft_id, -1)
2876: )

Line 2885: SELECT auction_header_id,auction_line_number FROM po_lines_merge_v pol

2881: ,FND_GLOBAL.login_id --LAST_UPDATE_LOGIN
2882: FROM PON_AUCTION_EXHIBIT_DETAILS paed
2883: WHERE (paed.auction_header_id, paed.associated_to_line)
2884: IN (
2885: SELECT auction_header_id,auction_line_number FROM po_lines_merge_v pol
2886: WHERE pol.po_header_id = po_autocreate_params.g_po_header_id
2887: AND pol.draft_id = Nvl(po_autocreate_params.g_draft_id, -1)
2888: )
2889: ;