APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on JAI_AP_INVOICE_LINES

Line 227: FROM ap_invoices_all aia, jai_ap_invoice_lines jail

223: AND pll.line_location_id = pda.line_location_id
224: AND pll.ship_to_organization_id = pn_organization_id)
225: UNION
226: SELECT aia.invoice_id
227: FROM ap_invoices_all aia, jai_ap_invoice_lines jail
228: WHERE aia.invoice_id = jail.invoice_id
229: AND jail.organization_id = pn_organization_id)
230: AND jrtr.SOURCE = jai_constants.source_ap
231: AND jrtr.invoice_id = ainvd.invoice_id

Line 315: FROM jai_ap_invoice_lines jail

311: --nvl(pn_organization_id, pll.ship_to_organization_id)
312: AND pda.po_distribution_id = ap_dist.po_distribution_id) OR
313: EXISTS
314: (SELECT 1
315: FROM jai_ap_invoice_lines jail
316: WHERE ap_dist.invoice_id = jail.invoice_id
317: and jail.organization_id = pn_organization_id))
318: ORDER BY ap_dist.invoice_distribution_id;
319: BEGIN

Line 1408: FROM jai_ap_invoice_lines

1404: AND line.match_type IS NOT NULL;
1405:
1406: CURSOR get_org_cur IS
1407: SELECT organization_id, location_id
1408: FROM jai_ap_invoice_lines
1409: WHERE invoice_id = p_invoice_id
1410: AND invoice_line_number =
1411: (SELECT parent_invoice_line_number
1412: FROM jai_ap_invoice_lines jail

Line 1412: FROM jai_ap_invoice_lines jail

1408: FROM jai_ap_invoice_lines
1409: WHERE invoice_id = p_invoice_id
1410: AND invoice_line_number =
1411: (SELECT parent_invoice_line_number
1412: FROM jai_ap_invoice_lines jail
1413: WHERE jail.invoice_line_number = p_invoice_line_number
1414: AND jail.invoice_id = p_invoice_id)
1415: AND parent_invoice_line_number IS NULL;
1416: