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_ALL

Line 84: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,

80: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
81: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
82: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
83: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
84: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
85: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
86: closed_code PO_LINES_ALL.closed_code%TYPE,
87: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
88: );

Line 85: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,

81: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
82: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
83: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
84: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
85: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
86: closed_code PO_LINES_ALL.closed_code%TYPE,
87: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
88: );
89:

Line 86: closed_code PO_LINES_ALL.closed_code%TYPE,

82: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
83: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
84: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
85: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
86: closed_code PO_LINES_ALL.closed_code%TYPE,
87: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
88: );
89:
90: FUNCTION get_req_line_info(p_req_line_id IN NUMBER) RETURN LINE_INFO;

Line 251: FROM po_lines_all

247: LOOP
248: BEGIN
249: SELECT 'ADD'
250: INTO l_line_action_tbl(i)
251: FROM po_lines_all
252: WHERE po_header_id = p_add_to_po_header_id
253: AND line_num = p_po_line_number_tbl(i);
254: EXCEPTION
255: WHEN NO_DATA_FOUND THEN

Line 341: l_po_line_num PO_LINES_ALL.line_num%TYPE;

337:
338: l_num_lines NUMBER;
339: l_key NUMBER;
340: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
341: l_po_line_num PO_LINES_ALL.line_num%TYPE;
342: l_req_line_id_to_compare PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
343: l_po_line_id_to_compare PO_LINES_ALL.po_line_id%TYPE;
344: l_progress_payment_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
345: l_message_code VARCHAR2(30) := NULL;

Line 343: l_po_line_id_to_compare PO_LINES_ALL.po_line_id%TYPE;

339: l_key NUMBER;
340: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
341: l_po_line_num PO_LINES_ALL.line_num%TYPE;
342: l_req_line_id_to_compare PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
343: l_po_line_id_to_compare PO_LINES_ALL.po_line_id%TYPE;
344: l_progress_payment_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
345: l_message_code VARCHAR2(30) := NULL;
346: l_token_name VARCHAR2(30) := NULL;
347: l_token_value VARCHAR2(2000) := NULL;

Line 435: FROM po_lines_all

431: OR EXISTS(
432: -- Select all PO lines that have the same PO line number as the
433: -- current line in the loop.
434: SELECT 'PO lines with same PO line number'
435: FROM po_lines_all
436: WHERE po_header_id = p_add_to_po_header_id
437: AND line_num = POSGT.index_num2 -- Same PO line number
438: )),
439: 'N' -- NVL to 'N' if no other req/PO lines with same PO line number

Line 515: FROM po_lines_all

511: -- If PO line with the same PO line number exists, check if matches
512: BEGIN
513: SELECT po_line_id
514: INTO l_po_line_id_to_compare
515: FROM po_lines_all
516: WHERE po_header_id = p_add_to_po_header_id
517: AND line_num = l_po_line_num;
518:
519: lines_match(

Line 1447: po_lines_all SRC_DOC_LINE

1443: NULL, -- closed code N/A for req line
1444: PRL.supplier_ref_number
1445: INTO l_req_line_info
1446: FROM po_requisition_lines_all PRL,
1447: po_lines_all SRC_DOC_LINE
1448: WHERE PRL.requisition_line_id = p_req_line_id
1449: AND SRC_DOC_LINE.po_header_id(+) = PRL.blanket_po_header_id
1450: AND SRC_DOC_LINE.line_num(+) = PRL.blanket_po_line_num;
1451:

Line 1518: FROM po_lines_all

1514: cancel_flag,
1515: closed_code,
1516: supplier_ref_number
1517: INTO l_po_line_info
1518: FROM po_lines_all
1519: WHERE po_line_id = p_po_line_id;
1520:
1521: IF (PO_LOG.d_proc) THEN
1522: PO_LOG.proc_end(d_mod);

Line 2349: , po_lines_all pol

2345: l_key
2346: , prl.requisition_line_id
2347: , pol.line_num
2348: FROM po_requisition_lines_all prl
2349: , po_lines_all pol
2350: , po_line_locations_all pll
2351: , po_lines_all src_line
2352: WHERE pol.po_header_id = p_add_to_po_header_id
2353: AND pll.po_line_id = pol.po_line_id

Line 2351: , po_lines_all src_line

2347: , pol.line_num
2348: FROM po_requisition_lines_all prl
2349: , po_lines_all pol
2350: , po_line_locations_all pll
2351: , po_lines_all src_line
2352: WHERE pol.po_header_id = p_add_to_po_header_id
2353: AND pll.po_line_id = pol.po_line_id
2354: AND prl.requisition_line_id = p_req_line_id_tbl(i)
2355: AND decode ( prl.item_id

Line 2619: FROM po_lines_all

2615: IF ( p_po_header_id IS NOT NULL )
2616: THEN
2617: SELECT nvl(max(line_num), 0)
2618: INTO x_max_po_line_num
2619: FROM po_lines_all
2620: WHERE po_header_id = p_po_header_id;
2621: END IF;
2622:
2623: -- Find max line number in the nested table of line numbers.