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_UTIL_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 223: -- po_requisition_lines_all

219: -- None
220: --Modifies:
221: -- None
222: --Locks:
223: -- po_requisition_lines_all
224: --Function:
225: -- Retrieves and locks all Requisition Lines that are specified in the input
226: -- nested table and are in the Req Pool.
227: --Parameters:

Line 348: FROM po_requisition_lines_all base_line,

344: INTO l_crosslinked_option_exist
345: FROM dual
346: WHERE EXISTS(
347: SELECT 'Cross Linked Child Exists'
348: FROM po_requisition_lines_all base_line,
349: po_requisition_lines_all child_line
350: WHERE base_line.requisition_line_id = Nvl(child_line.clm_base_line_num,-1)
351: AND Nvl(base_line.group_line_id,-1) <> Nvl(child_line.group_line_id,-1)
352: AND child_line.group_line_id =p_req_line_id

Line 349: po_requisition_lines_all child_line

345: FROM dual
346: WHERE EXISTS(
347: SELECT 'Cross Linked Child Exists'
348: FROM po_requisition_lines_all base_line,
349: po_requisition_lines_all child_line
350: WHERE base_line.requisition_line_id = Nvl(child_line.clm_base_line_num,-1)
351: AND Nvl(base_line.group_line_id,-1) <> Nvl(child_line.group_line_id,-1)
352: AND child_line.group_line_id =p_req_line_id
353: );

Line 405: ( select 1 from po_requisition_lines_all prla where requisition_line_id = p_req_line_id

401: Select FND_API.G_TRUE
402: INTO l_is_par_option_line_editable
403: from dual
404: where EXISTS
405: ( select 1 from po_requisition_lines_all prla where requisition_line_id = p_req_line_id
406: and par_draft_id is not null
407: AND
408: ((clm_base_line_num IS NULL AND group_line_id IS NULL ) OR
409: ( clm_base_line_num IS NULL AND

Line 466: CURSOR C_lines(c_req_line_id po_requisition_lines_all.requisition_line_id%TYPE) IS

462: dwb. this value can be around multiple clin - slin structures
463: so they should not be considered for grouping.
464: */
465:
466: CURSOR C_lines(c_req_line_id po_requisition_lines_all.requisition_line_id%TYPE) IS
467: SELECT Nvl(( CASE
468: WHEN ( (clm_base_line_num = 0) AND par_line_id IS NOT NULL )THEN NULL
469: ELSE clm_base_line_num
470: END ), -1) clm_base_line_num

Line 471: FROM po_requisition_lines_all

467: SELECT Nvl(( CASE
468: WHEN ( (clm_base_line_num = 0) AND par_line_id IS NOT NULL )THEN NULL
469: ELSE clm_base_line_num
470: END ), -1) clm_base_line_num
471: FROM po_requisition_lines_all
472: WHERE requisition_line_id IN (c_req_line_id,(SELECT group_line_id
473: FROM po_requisition_lines_all
474: WHERE requisition_line_id = c_req_line_id))
475: OR group_line_id IN (c_req_line_id,(SELECT group_line_id

Line 473: FROM po_requisition_lines_all

469: ELSE clm_base_line_num
470: END ), -1) clm_base_line_num
471: FROM po_requisition_lines_all
472: WHERE requisition_line_id IN (c_req_line_id,(SELECT group_line_id
473: FROM po_requisition_lines_all
474: WHERE requisition_line_id = c_req_line_id))
475: OR group_line_id IN (c_req_line_id,(SELECT group_line_id
476: FROM po_requisition_lines_all
477: WHERE requisition_line_id = c_req_line_id

Line 476: FROM po_requisition_lines_all

472: WHERE requisition_line_id IN (c_req_line_id,(SELECT group_line_id
473: FROM po_requisition_lines_all
474: WHERE requisition_line_id = c_req_line_id))
475: OR group_line_id IN (c_req_line_id,(SELECT group_line_id
476: FROM po_requisition_lines_all
477: WHERE requisition_line_id = c_req_line_id
478: AND ( par_line_id IS NULL OR
479: (par_line_id IS NOT NULL AND group_line_id <> 0) )));
480:

Line 482: CURSOR P_lines(c_req_line_id po_requisition_lines_all.requisition_line_id%TYPE) IS

478: AND ( par_line_id IS NULL OR
479: (par_line_id IS NOT NULL AND group_line_id <> 0) )));
480:
481:
482: CURSOR P_lines(c_req_line_id po_requisition_lines_all.requisition_line_id%TYPE) IS
483: SELECT requisition_line_id
484: FROM po_requisition_lines_all
485: WHERE requisition_line_id IN (c_req_line_id,(SELECT group_line_id
486: FROM po_requisition_lines_all

Line 484: FROM po_requisition_lines_all

480:
481:
482: CURSOR P_lines(c_req_line_id po_requisition_lines_all.requisition_line_id%TYPE) IS
483: SELECT requisition_line_id
484: FROM po_requisition_lines_all
485: WHERE requisition_line_id IN (c_req_line_id,(SELECT group_line_id
486: FROM po_requisition_lines_all
487: WHERE requisition_line_id = c_req_line_id))
488: OR group_line_id IN (c_req_line_id,(SELECT group_line_id

Line 486: FROM po_requisition_lines_all

482: CURSOR P_lines(c_req_line_id po_requisition_lines_all.requisition_line_id%TYPE) IS
483: SELECT requisition_line_id
484: FROM po_requisition_lines_all
485: WHERE requisition_line_id IN (c_req_line_id,(SELECT group_line_id
486: FROM po_requisition_lines_all
487: WHERE requisition_line_id = c_req_line_id))
488: OR group_line_id IN (c_req_line_id,(SELECT group_line_id
489: FROM po_requisition_lines_all
490: WHERE requisition_line_id = c_req_line_id

Line 489: FROM po_requisition_lines_all

485: WHERE requisition_line_id IN (c_req_line_id,(SELECT group_line_id
486: FROM po_requisition_lines_all
487: WHERE requisition_line_id = c_req_line_id))
488: OR group_line_id IN (c_req_line_id,(SELECT group_line_id
489: FROM po_requisition_lines_all
490: WHERE requisition_line_id = c_req_line_id
491: AND ( par_line_id IS NULL OR
492: (par_line_id IS NOT NULL AND group_line_id <> 0) )));
493: