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_HEADERS

Line 374: po_headers_interface intf_headers,

370: SELECT intf_headers.interface_header_id,
371: intf_lines.interface_line_id,
372: intf_lines.line_num
373: FROM po_lines_interface intf_lines,
374: po_headers_interface intf_headers,
375: po_lines txn_lines
376: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
377: AND intf_headers.po_header_id = txn_lines.po_header_id
378: AND intf_lines.processing_id = p_request_processing_id

Line 390: FROM po_headers_interface intf_headers,

386: p_request_processing_round_num NUMBER) IS
387: SELECT intf_headers.interface_header_id,
388: intf_lines.interface_line_id,
389: intf_lines.line_num
390: FROM po_headers_interface intf_headers,
391: po_lines_interface intf_lines,
392: po_lines_draft_all draft_lines
393: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
394: AND intf_headers.draft_id = draft_lines.draft_id

Line 593: po_headers_interface intf_headers

589: SELECT intf_lines.interface_line_id,
590: intf_headers.interface_header_id,
591: intf_lines.action
592: FROM po_lines_interface intf_lines,
593: po_headers_interface intf_headers
594: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
595: AND intf_lines.processing_id = p_request_processing_id
596: AND intf_headers.processing_round_num = p_request_processing_round_num
597: AND intf_headers.processing_id = p_request_processing_id

Line 891: po_headers_interface intf_headers,

887: intf_lines.from_header_disp,
888: intf_lines.from_line_disp
889:
890: FROM po_lines_interface intf_lines,
891: po_headers_interface intf_headers,
892: po_headers_draft_all draft_headers
893: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
894: AND intf_headers.draft_id = draft_headers.draft_id
895: AND intf_headers.po_header_id = draft_headers.po_header_id

Line 892: po_headers_draft_all draft_headers

888: intf_lines.from_line_disp
889:
890: FROM po_lines_interface intf_lines,
891: po_headers_interface intf_headers,
892: po_headers_draft_all draft_headers
893: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
894: AND intf_headers.draft_id = draft_headers.draft_id
895: AND intf_headers.po_header_id = draft_headers.po_header_id
896: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1076: po_headers_interface intf_headers,

1072: intf_lines.from_line_disp
1073:
1074:
1075: FROM po_lines_interface intf_lines,
1076: po_headers_interface intf_headers,
1077: po_headers txn_headers
1078: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1079: AND intf_headers.po_header_id = txn_headers.po_header_id
1080: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1077: po_headers txn_headers

1073:
1074:
1075: FROM po_lines_interface intf_lines,
1076: po_headers_interface intf_headers,
1077: po_headers txn_headers
1078: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1079: AND intf_headers.po_header_id = txn_headers.po_header_id
1080: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1081: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

Line 1261: po_headers_interface intf_headers,

1257: intf_lines.from_header_disp,
1258: intf_lines.from_line_disp
1259:
1260: FROM po_lines_interface intf_lines,
1261: po_headers_interface intf_headers,
1262: po_headers txn_headers
1263: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1264: AND intf_headers.po_header_id = txn_headers.po_header_id
1265: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1262: po_headers txn_headers

1258: intf_lines.from_line_disp
1259:
1260: FROM po_lines_interface intf_lines,
1261: po_headers_interface intf_headers,
1262: po_headers txn_headers
1263: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1264: AND intf_headers.po_header_id = txn_headers.po_header_id
1265: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1266: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

Line 1451: po_headers_interface intf_headers,

1447: intf_lines.from_header_disp,
1448: intf_lines.from_line_disp
1449:
1450: FROM po_lines_interface intf_lines,
1451: po_headers_interface intf_headers,
1452: po_headers txn_headers
1453: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1454: AND intf_headers.po_header_id = txn_headers.po_header_id
1455: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1452: po_headers txn_headers

1448: intf_lines.from_line_disp
1449:
1450: FROM po_lines_interface intf_lines,
1451: po_headers_interface intf_headers,
1452: po_headers txn_headers
1453: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1454: AND intf_headers.po_header_id = txn_headers.po_header_id
1455: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1456: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

Line 1644: po_headers_interface intf_headers,

1640: intf_lines.from_header_disp,
1641: intf_lines.from_line_disp
1642:
1643: FROM po_lines_interface intf_lines,
1644: po_headers_interface intf_headers,
1645: po_headers txn_headers
1646: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1647: AND intf_headers.po_header_id = txn_headers.po_header_id
1648: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1645: po_headers txn_headers

1641: intf_lines.from_line_disp
1642:
1643: FROM po_lines_interface intf_lines,
1644: po_headers_interface intf_headers,
1645: po_headers txn_headers
1646: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1647: AND intf_headers.po_header_id = txn_headers.po_header_id
1648: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1649: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

Line 1837: po_headers_interface intf_headers,

1833: intf_lines.from_header_disp,
1834: intf_lines.from_line_disp
1835:
1836: FROM po_lines_interface intf_lines,
1837: po_headers_interface intf_headers,
1838: po_headers_draft_all draft_headers
1839: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1840: AND intf_headers.draft_id = draft_headers.draft_id
1841: AND intf_headers.po_header_id = draft_headers.po_header_id

Line 1838: po_headers_draft_all draft_headers

1834: intf_lines.from_line_disp
1835:
1836: FROM po_lines_interface intf_lines,
1837: po_headers_interface intf_headers,
1838: po_headers_draft_all draft_headers
1839: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1840: AND intf_headers.draft_id = draft_headers.draft_id
1841: AND intf_headers.po_header_id = draft_headers.po_header_id
1842: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 4771: FROM po_headers txn_headers, po_lines txn_lines

4767: SELECT DISTINCT
4768: p_key,
4769: p_index_tbl(i),
4770: txn_lines.item_id
4771: FROM po_headers txn_headers, po_lines txn_lines
4772: WHERE txn_headers.po_header_id = txn_lines.po_header_id
4773: AND p_item_tbl(i) IS NULL
4774: AND x_item_id_tbl(i) IS NULL
4775: AND p_vendor_product_num_tbl(i) IS NOT NULL

Line 9426: FROM po_headers_all phi

9422: FROM dual;
9423:
9424: UPDATE po_session_gt psg
9425: SET psg.num2 = ( SELECT phi.po_header_id
9426: FROM po_headers_all phi
9427: WHERE clm_document_number = psg.char1
9428: )
9429: WHERE psg.char1 IS NOT NULL
9430: AND psg.num2 IS NULL;

Line 9742: FROM po_headers_draft_all phd, po_lines_interface PLI, po_headers_interface phi

9738: FROM dual;
9739:
9740: UPDATE po_session_gt psg
9741: SET psg.num4 = ( SELECT phd.clm_source_document_id
9742: FROM po_headers_draft_all phd, po_lines_interface PLI, po_headers_interface phi
9743: WHERE PLI.interface_line_id = psg.num3
9744: AND PLI.interface_header_id = phi.interface_header_id
9745: AND phi.po_header_id = phd.po_header_id
9746: )