eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_LINES_MERGE_V

Line 369: FROM po_lines_merge_v

365: LOOP
366: BEGIN
367: SELECT 'ADD'
368: INTO l_line_action_tbl(i)
369: FROM po_lines_merge_v
370: WHERE po_header_id = p_add_to_po_header_id
371: AND line_num = p_po_line_number_tbl(i)
372: AND nvl(draft_id,-1) = nvl(p_draft_id,-1);
373: EXCEPTION

Line 634: --autocreate grouping, need to pass in the draft_id and get the po_line_id_to_compare from po_lines_merge_v, so that 'add to mod' case is taken care of.

630: -- Check for PO line mismatch if all req lines match
631: IF (l_message_code IS NULL)
632: THEN
633: -- If PO line with the same PO line number exists, check if matches
634: --autocreate grouping, need to pass in the draft_id and get the po_line_id_to_compare from po_lines_merge_v, so that 'add to mod' case is taken care of.
635: BEGIN
636: SELECT po_line_id
637: INTO l_po_line_id_to_compare
638: FROM po_lines_merge_v

Line 638: FROM po_lines_merge_v

634: --autocreate grouping, need to pass in the draft_id and get the po_line_id_to_compare from po_lines_merge_v, so that 'add to mod' case is taken care of.
635: BEGIN
636: SELECT po_line_id
637: INTO l_po_line_id_to_compare
638: FROM po_lines_merge_v
639: WHERE po_header_id = p_add_to_po_header_id
640: AND draft_id = p_draft_id
641: AND line_num = l_po_line_num;
642:

Line 3007: FROM po_lines_merge_v /* changing to po_lines_merge_v and passing in the draft_id, for the 'add to mods' flow*/

3003: ,CLM_INFO_FLAG
3004: ,CLM_BASE_LINE_NUM
3005: ,category_id --bugfix#16097884
3006: INTO l_po_line_info
3007: FROM po_lines_merge_v /* changing to po_lines_merge_v and passing in the draft_id, for the 'add to mods' flow*/
3008: WHERE po_line_id = p_po_line_id
3009: AND draft_id = p_draft_id;
3010:
3011: IF (PO_LOG.d_proc) THEN

Line 4196: , po_lines_merge_v pol

4192: l_key
4193: , prl.requisition_line_id
4194: , pol.line_num
4195: FROM po_requisition_lines_all prl
4196: , po_lines_merge_v pol
4197: , po_line_locations_merge_v pll
4198: , po_lines_merge_v src_line
4199: WHERE pol.po_header_id = p_add_to_po_header_id
4200: AND pol.draft_id = p_draft_id

Line 4198: , po_lines_merge_v src_line

4194: , pol.line_num
4195: FROM po_requisition_lines_all prl
4196: , po_lines_merge_v pol
4197: , po_line_locations_merge_v pll
4198: , po_lines_merge_v src_line
4199: WHERE pol.po_header_id = p_add_to_po_header_id
4200: AND pol.draft_id = p_draft_id
4201: AND pll.po_line_id = pol.po_line_id
4202: AND pll.draft_id = pol.draft_id

Line 4349: , po_lines_merge_v pol

4345: , prl.requisition_line_id
4346: , pol.line_num
4347: , pol.line_num_display
4348: FROM po_requisition_lines_all prl
4349: , po_lines_merge_v pol
4350: , po_line_locations_merge_v pll
4351: , po_lines_merge_v src_line
4352: WHERE pol.po_header_id = p_add_to_po_header_id
4353: AND nvl(pol.draft_id,-1) = nvl(p_draft_id,-1)

Line 4351: , po_lines_merge_v src_line

4347: , pol.line_num_display
4348: FROM po_requisition_lines_all prl
4349: , po_lines_merge_v pol
4350: , po_line_locations_merge_v pll
4351: , po_lines_merge_v src_line
4352: WHERE pol.po_header_id = p_add_to_po_header_id
4353: AND nvl(pol.draft_id,-1) = nvl(p_draft_id,-1)
4354: AND pll.po_line_id = pol.po_line_id
4355: AND nvl(pll.draft_id,-1) = nvl(pol.draft_id,-1)

Line 4636: FROM po_lines_merge_v

4632: THEN
4633:
4634: SELECT nvl(max(line_num), 0)
4635: INTO x_max_po_line_num
4636: FROM po_lines_merge_v
4637: WHERE po_header_id = p_po_header_id;
4638: --AND nvl(draft_id,-1) = nvl(l_draft_id,-1);
4639:
4640: END IF;

Line 4715: FROM po_lines_merge_v

4711: IF ( p_po_header_id IS NOT NULL )
4712: THEN
4713: SELECT nvl(max(line_num_display), '0000')
4714: INTO x_max_po_line_num
4715: FROM po_lines_merge_v
4716: WHERE po_header_id = p_po_header_id
4717: --AND draft_id = p_draft_id
4718: and group_line_id is null
4719: and CLM_EXHIBIT_NAME IS null; --Bug 16572476

Line 5046: FROM po_lines_merge_v

5042:
5043: BEGIN
5044: SELECT po_line_id, Decode(clm_option_indicator, 'O', 'Y', 'N')
5045: INTO l_po_line_id, l_is_option_line
5046: FROM po_lines_merge_v
5047: WHERE po_header_id = p_po_header_id AND
5048: line_num = p_po_line_num AND
5049: draft_id <> -1;
5050: EXCEPTION

Line 5064: FROM po_lines_merge_v

5060: END LOOP;
5061: ELSE
5062: SELECT Max(line_num_display)
5063: INTO l_max_slin_num
5064: FROM po_lines_merge_v
5065: WHERE group_line_id = l_po_line_id AND
5066: draft_id <> -1 AND
5067: Nvl(clm_info_flag, 'N') = 'Y' AND
5068: group_line_id IS NOT NULL;

Line 5162: po_lines_merge_v plm

5158: INTO l_lock_available
5159: FROM dual
5160: WHERE NOT EXISTS (SELECT 'Another Mod has F lock'
5161: FROM po_entity_locks poel,
5162: po_lines_merge_v plm
5163: WHERE plm.po_line_id = poel.entity_pk1
5164: AND plm.po_header_id = p_add_to_po_header_id
5165: AND plm.draft_id = p_draft_id
5166: AND plm.line_num = p_po_line_number_tbl(i)

Line 5535: FROM PO_LINES_MERGE_V

5531:
5532: --Setting the po_line_id of the clins where action is 'ADD'
5533: UPDATE po_session_gt
5534: SET num4 = (select po_line_id
5535: FROM PO_LINES_MERGE_V
5536: where PO_HEADER_ID = p_add_to_po_header_id
5537: AND LINE_NUM_DISPLAY = char1
5538: AND ROWNUM=1)
5539: where num2 is null -- group line id

Line 5649: FROM po_lines_merge_v

5645: BEGIN
5646:
5647: SELECT line_num
5648: INTO l_line_num
5649: FROM po_lines_merge_v
5650: WHERE nvl(draft_id,-1) = nvl(p_draft_id,-1)
5651: --Bug 13552726 : While creating new modification the draft_id was null
5652: --Hence the query returned no value. The line_num was not set and no
5653: --validations were fired.

Line 5708: FROM po_lines_merge_v plm,

5704: d_position := 10;
5705: BEGIN
5706: SELECT line_num, line_num_display
5707: INTO x_po_line_num, x_po_line_num_disp
5708: FROM po_lines_merge_v plm,
5709: po_line_locations_merge_v pllm
5710: WHERE plm.po_line_id = pllm.po_line_id
5711: AND plm.draft_id = pllm.draft_id
5712: AND pllm.line_location_id = p_po_shipment_id