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_PDOI_LINE_PROCESS_PVT dependencies on PO_LINES_DRAFT_ALL

Line 307: po_lines_draft_all draft_lines

303: intf_lines.interface_line_id,
304: intf_lines.line_num
305: FROM po_headers_interface intf_headers,
306: po_lines_interface intf_lines,
307: po_lines_draft_all draft_lines
308: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
309: AND intf_headers.draft_id = draft_lines.draft_id
310: AND intf_headers.po_header_id = draft_lines.po_header_id
311: AND intf_lines.processing_id = p_request_processing_id

Line 2695: FROM po_lines_draft_all

2691: l_num_list(i),
2692: order_type_lookup_code,
2693: item_id,
2694: job_id
2695: FROM po_lines_draft_all
2696: WHERE po_line_id = x_lines.po_line_id_tbl(i)
2697: AND draft_id = x_lines.draft_id_tbl(i);
2698:
2699: d_position := 20;

Line 2712: FROM po_lines_draft_all

2708: job_id
2709: FROM po_lines_all
2710: WHERE po_line_id = x_lines.po_line_id_tbl(i)
2711: AND NOT EXISTS (SELECT 1
2712: FROM po_lines_draft_all
2713: WHERE po_line_id = x_lines.po_line_id_tbl(i)
2714: AND draft_id = x_lines.draft_id_tbl(i));
2715:
2716: d_position := 30;

Line 5765: FROM po_lines_draft_all

5761: INSERT INTO po_session_gt(key, num1, num2)
5762: SELECT l_key,
5763: p_index_tbl(i),
5764: po_line_id
5765: FROM po_lines_draft_all
5766: WHERE draft_id = x_lines.draft_id_tbl(i)
5767: AND po_header_id = x_lines.po_header_id_tbl(i)
5768: AND line_num = x_lines.line_num_tbl(i)
5769: AND NVL(delete_flag, 'N') <> 'Y';

Line 5950: FROM po_lines_draft_all

5946: SELECT l_key,
5947: l_processing_line_tbl(i),
5948: po_line_id,
5949: line_num
5950: FROM po_lines_draft_all
5951: WHERE x_lines.item_id_tbl(i) IS NOT NULL
5952: AND draft_id = x_lines.draft_id_tbl(i)
5953: AND po_header_id = x_lines.po_header_id_tbl(i)
5954: AND item_id = x_lines.item_id_tbl(i)

Line 5972: FROM po_lines_draft_all

5968: SELECT l_key,
5969: l_processing_line_tbl(i),
5970: po_line_id,
5971: line_num
5972: FROM po_lines_draft_all
5973: WHERE x_lines.item_id_tbl(i) IS NULL
5974: AND draft_id = x_lines.draft_id_tbl(i)
5975: AND po_header_id = x_lines.po_header_id_tbl(i)
5976: AND item_description = x_lines.item_desc_tbl(i)

Line 6469: FROM po_lines_draft_all draft_lines

6465: p_key,
6466: x_processing_row_tbl(i),
6467: draft_lines.po_line_id,
6468: draft_lines.line_num
6469: FROM po_lines_draft_all draft_lines
6470: WHERE draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6471: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
6472: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
6473: AND draft_lines.item_description = x_lines.item_desc_tbl(i)

Line 6499: FROM po_lines_draft_all draft_lines

6495: txn_lines.line_num
6496: FROM po_lines txn_lines
6497: WHERE txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6498: AND NOT EXISTS ( SELECT 1
6499: FROM po_lines_draft_all draft_lines
6500: WHERE draft_lines.po_line_id = txn_lines.po_line_id
6501: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
6502: AND txn_lines.item_description = x_lines.item_desc_tbl(i)
6503: AND (x_lines.category_tbl(i) IS NULL OR

Line 6743: FROM po_lines_draft_all draft_lines

6739: p_key,
6740: x_processing_row_tbl(i),
6741: draft_lines.po_line_id,
6742: draft_lines.line_num
6743: FROM po_lines_draft_all draft_lines
6744: WHERE x_lines.item_tbl(i) IS NOT NULL
6745: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6746: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
6747: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)

Line 6782: FROM po_lines_draft_all draft_lines

6778: FROM po_lines txn_lines
6779: WHERE x_lines.item_tbl(i) IS NOT NULL
6780: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
6781: AND NOT EXISTS ( SELECT 1
6782: FROM po_lines_draft_all draft_lines
6783: WHERE draft_lines.po_line_id = txn_lines.po_line_id
6784: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
6785: AND EXISTS (SELECT 1
6786: FROM mtl_system_items items

Line 7025: FROM po_lines_draft_all draft_lines

7021: p_key,
7022: x_processing_row_tbl(i),
7023: draft_lines.po_line_id,
7024: draft_lines.line_num
7025: FROM po_lines_draft_all draft_lines
7026: WHERE x_lines.item_tbl(i) IS NULL
7027: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
7028: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7029: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)

Line 7057: FROM po_lines_draft_all draft_lines

7053: WHERE x_lines.item_tbl(i) IS NULL
7054: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
7055: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7056: AND NOT EXISTS ( SELECT 1
7057: FROM po_lines_draft_all draft_lines
7058: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7059: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7060: AND txn_lines.vendor_product_num = x_lines.vendor_product_num_tbl(i)
7061: AND NVL(x_lines.supplier_part_auxid_tbl(i),

Line 7283: FROM po_lines_draft_all draft_lines

7279: p_key,
7280: x_processing_row_tbl(i),
7281: draft_lines.po_line_id,
7282: draft_lines.line_num
7283: FROM po_lines_draft_all draft_lines
7284: WHERE x_lines.item_tbl(i) IS NULL
7285: AND x_lines.vendor_product_num_tbl(i) IS NULL
7286: AND x_lines.job_name_tbl(i) IS NOT NULL
7287: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)

Line 7318: FROM po_lines_draft_all draft_lines

7314: AND x_lines.vendor_product_num_tbl(i) IS NULL
7315: AND x_lines.job_name_tbl(i) IS NOT NULL
7316: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7317: AND NOT EXISTS ( SELECT 1
7318: FROM po_lines_draft_all draft_lines
7319: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7320: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7321: AND EXISTS (SELECT 1
7322: FROM per_jobs_vl

Line 7538: FROM po_lines_draft_all draft_lines

7534: p_key,
7535: x_processing_row_tbl(i),
7536: draft_lines.po_line_id,
7537: draft_lines.line_num
7538: FROM po_lines_draft_all draft_lines
7539: WHERE x_lines.item_tbl(i) IS NULL
7540: AND x_lines.vendor_product_num_tbl(i) IS NULL
7541: AND x_lines.job_name_tbl(i) IS NULL
7542: AND x_lines.line_num_tbl(i) IS NOT NULL

Line 7571: FROM po_lines_draft_all draft_lines

7567: AND x_lines.job_name_tbl(i) IS NULL
7568: AND x_lines.line_num_tbl(i) IS NOT NULL
7569: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7570: AND NOT EXISTS ( SELECT 1
7571: FROM po_lines_draft_all draft_lines
7572: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7573: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7574: AND txn_lines.line_num = x_lines.line_num_tbl(i)
7575: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)