APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on AP_INVOICE_LINES_ALL

Line 319: ap_invoice_lines_all ail

315: CURSOR c_get_invoice_discarded_flag
316: IS
317: SELECT nvl(discarded_flag,'N')
318: FROM ap_invoices_all aia,
319: ap_invoice_lines_all ail
320: WHERE aia.invoice_id = ail.invoice_id
321: AND aia.invoice_id = pn_document_id
322: AND ail.line_number = pv_document_line_id;
323:

Line 332: lv_discarded_flag ap_invoice_lines_all.discarded_flag%TYPE;

328: AND invoice_line_number = pv_document_line_id
329: AND nvl(reversal_flag,'N') = 'Y'
330: AND parent_reversal_id IS NOT NULL;
331:
332: lv_discarded_flag ap_invoice_lines_all.discarded_flag%TYPE;
333: /*Added by Qinglei 21-Dec-2011 for bug#1340559 end */
334: --Added by Qiong for reverse charge bug#16001407 begin
335: CURSOR c_get_settle_payment_date
336: IS SELECT payment_date

Line 547: ap_invoice_lines_all ail

543: ,pv_invoice_line_num VARCHAR2)
544: IS
545: SELECT nvl(discarded_flag,'N')
546: FROM ap_invoices_all aia,
547: ap_invoice_lines_all ail
548: WHERE aia.invoice_id = ail.invoice_id
549: AND aia.invoice_id = pn_invoice_id
550: AND ail.line_number = pv_invoice_line_num;
551:

Line 552: lv_discarded_flag ap_invoice_lines_all.discarded_flag%TYPE;

548: WHERE aia.invoice_id = ail.invoice_id
549: AND aia.invoice_id = pn_invoice_id
550: AND ail.line_number = pv_invoice_line_num;
551:
552: lv_discarded_flag ap_invoice_lines_all.discarded_flag%TYPE;
553: --Added by Qinglei for bug#13405591 13-Dec-2011 end
554:
555: cursor c_get_organization_name (cp_organization_id hr_organization_units.organization_id%type)
556: is

Line 1790: , ap_invoice_lines_all apla

1786: ,apa.vendor_id party_id
1787: ,jasl.organization_id organization_id
1788: ,jasl.location_id location_id
1789: from ap_invoices_all apa
1790: , ap_invoice_lines_all apla
1791: , po_vendors pov
1792: , jai_ap_invoice_lines jasl
1793: where
1794: apa.invoice_id = p_document_id

Line 1859: FROM ap_invoice_lines_all aila

1855: /* Added by Wenqiong for bug13462951 on Feb 09, 2012 Begin*/
1856: CURSOR c_get_inv_prepay
1857: IS
1858: SELECT abs(nvl(SUM(aila.amount),0))
1859: FROM ap_invoice_lines_all aila
1860: WHERE aila.invoice_id = p_document_id
1861: AND aila.line_type_lookup_code = 'PREPAY';
1862:
1863: CURSOR c_total_ap_amount IS

Line 2082: ap_invoice_lines_all aila

2078: /* end -bug 13430127 */
2079: CURSOR c_get_dist_details IS
2080: SELECT aila.line_number, aila.match_type
2081: FROM ap_invoice_distributions_all aida,
2082: ap_invoice_lines_all aila
2083: WHERE aida.invoice_id = p_document_id
2084: AND aida.invoice_distribution_id = p_document_line_id
2085: AND aida.invoice_line_number = aila.line_number
2086: AND aila.invoice_id = p_document_id;

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:

Line 2097: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap

2093: AND ap.line_number = pn_line_number;
2094:
2095: CURSOR get_rcpt_matched_org_cur(pn_line_number NUMBER) IS
2096: SELECT rcv.organization_id, rcv.location_id
2097: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap
2098: WHERE ap.rcv_transaction_id = rcv.transaction_id
2099: AND ap.invoice_id = p_document_id
2100: AND ap.line_number = pn_line_number;
2101:

Line 2120: , ap_invoice_lines_all apla

2116: ,apa.vendor_id party_id
2117: ,NULL organization_id
2118: ,NULL location_id
2119: from ap_invoices_all apa
2120: , ap_invoice_lines_all apla
2121: , po_vendors pov
2122: , ap_invoice_distributions_all aida
2123: where
2124: apa.invoice_id = p_document_id