APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 1441: , po_line_locations_all poll /*6841116*/

1437: ,hl.inventory_organization_id organization_id /* Added by vkantamn for Bug#6083978 */
1438: ,poll.ship_to_location_id location_id
1439: from po_headers_all poh
1440: , po_lines_all pol
1441: , po_line_locations_all poll /*6841116*/
1442: , mtl_system_items msi
1443: , po_vendors pov
1444: , hr_locations hl /* Added by vkantamn for Bug#6083978 */
1445: -- , financials_system_parameters fsp /* Commented by vkantamn for Bug#6083978 */

Line 2090: FROM po_line_locations_all po,ap_invoice_lines_all ap

2086: AND aila.invoice_id = p_document_id;
2087:
2088: CURSOR get_po_matched_org_cur(pn_line_number NUMBER) IS
2089: SELECT po.ship_to_organization_id, po.ship_to_location_id
2090: FROM po_line_locations_all po,ap_invoice_lines_all ap
2091: WHERE po.line_location_id = ap.po_line_location_id
2092: AND ap.invoice_id = p_document_id
2093: AND ap.line_number = pn_line_number;
2094: