APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_HEADERS_INTERFACE

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 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 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 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 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 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 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: )