APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_HEADERS_INTERFACE

Line 289: po_headers_interface intf_headers,

285: SELECT intf_headers.interface_header_id,
286: intf_lines.interface_line_id,
287: intf_lines.line_num
288: FROM po_lines_interface intf_lines,
289: po_headers_interface intf_headers,
290: po_lines txn_lines
291: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
292: AND intf_headers.po_header_id = txn_lines.po_header_id
293: AND intf_lines.processing_id = p_request_processing_id

Line 305: FROM po_headers_interface intf_headers,

301: p_request_processing_round_num NUMBER) IS
302: SELECT intf_headers.interface_header_id,
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

Line 508: po_headers_interface intf_headers

504: SELECT intf_lines.interface_line_id,
505: intf_headers.interface_header_id,
506: intf_lines.action
507: FROM po_lines_interface intf_lines,
508: po_headers_interface intf_headers
509: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
510: AND intf_lines.processing_id = p_request_processing_id
511: AND intf_headers.processing_round_num = p_request_processing_round_num
512: AND intf_headers.processing_id = p_request_processing_id

Line 758: po_headers_interface intf_headers,

754: NULL, -- origin_line_num
755: FND_API.g_FALSE, -- match_line_found
756: NULL -- allow_desc_update_flag_tbl
757: FROM po_lines_interface intf_lines,
758: po_headers_interface intf_headers,
759: po_headers_draft_all draft_headers
760: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
761: AND intf_headers.draft_id = draft_headers.draft_id
762: AND intf_headers.po_header_id = draft_headers.po_header_id

Line 891: po_headers_interface intf_headers,

887: NULL, -- origin_line_num
888: FND_API.g_FALSE, -- match_line_found
889: NULL -- allow_desc_update_flag_tbl
890: FROM po_lines_interface intf_lines,
891: po_headers_interface intf_headers,
892: po_headers txn_headers
893: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
894: AND intf_headers.po_header_id = txn_headers.po_header_id
895: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1025: po_headers_interface intf_headers,

1021: NULL, -- origin_line_num
1022: FND_API.g_FALSE, -- match_line_found
1023: NULL -- allow_desc_update_flag_tbl
1024: FROM po_lines_interface intf_lines,
1025: po_headers_interface intf_headers,
1026: po_headers txn_headers
1027: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1028: AND intf_headers.po_header_id = txn_headers.po_header_id
1029: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1162: po_headers_interface intf_headers,

1158: NULL, -- origin_line_num
1159: FND_API.g_FALSE, -- match_line_found
1160: NULL -- allow_desc_update_flag_tbl
1161: FROM po_lines_interface intf_lines,
1162: po_headers_interface intf_headers,
1163: po_headers txn_headers
1164: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1165: AND intf_headers.po_header_id = txn_headers.po_header_id
1166: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1303: po_headers_interface intf_headers,

1299: NULL, -- origin_line_num
1300: FND_API.g_FALSE, -- match_line_found
1301: NULL -- allow_desc_update_flag_tbl
1302: FROM po_lines_interface intf_lines,
1303: po_headers_interface intf_headers,
1304: po_headers txn_headers
1305: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1306: AND intf_headers.po_header_id = txn_headers.po_header_id
1307: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id