APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on AP_INVOICES_ALL

Line 318: FROM ap_invoices_all aia,

314: /*Added by Qinglei 21-Dec-2011 for bug#1340559 begin */
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;

Line 546: FROM ap_invoices_all aia,

542: cursor c_get_invoice_discarded_flag(pn_invoice_id NUMBER
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;

Line 641: cursor c_st_transprt_inv_details(cp_invoice_id ap_invoices_all.invoice_id%type)/* Changes by nprashar , Forward porting from bug 7172723*/

637: ,hz_parties hzp
638: where hzca.cust_account_id = cp_party_id
639: and hzp.party_id = hzca.party_id;
640:
641: cursor c_st_transprt_inv_details(cp_invoice_id ap_invoices_all.invoice_id%type)/* Changes by nprashar , Forward porting from bug 7172723*/
642: is
643: select
644: aia.invoice_num,
645: substr(aia.invoice_num,instr(aia.invoice_num,'/',1,1)+1,instr(aia.invoice_num,'/',1,2)-instr(aia.invoice_num,'/',1,1)-1) rcp_no,

Line 652: ap_invoices_all aia

648: from
649: po_headers_all pha,
650: rcv_transactions rt,
651: rcv_shipment_headers rsh,
652: ap_invoices_all aia
653: where
654: rsh.receipt_num=substr(aia.invoice_num,instr(aia.invoice_num,'/',1,1)+1,instr(aia.invoice_num,'/',1,2)-instr(aia.invoice_num,'/',1,1)-1) AND
655: rsh.shipment_header_id=rt.shipment_header_id AND
656: rt.po_header_id=pha.po_header_id AND

Line 661: cursor c_st_transprt_party_details(cp_invoice_id ap_invoices_all.invoice_id%type) /* Changes by nprashar , Forward porting from bug 7172723*/

657: pha.org_id=aia.org_id AND
658: aia.invoice_id=cp_invoice_id
659: and rownum=1;
660:
661: cursor c_st_transprt_party_details(cp_invoice_id ap_invoices_all.invoice_id%type) /* Changes by nprashar , Forward porting from bug 7172723*/
662: IS
663: select pv.vendor_name,pv.vendor_id from
664: jai_rgm_trx_refs jrtr,
665: po_vendors pv

Line 1789: from ap_invoices_all apa

1785: ,NULL inventory_item_id
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

Line 1865: from ap_invoices_all

1861: AND aila.line_type_lookup_code = 'PREPAY';
1862:
1863: CURSOR c_total_ap_amount IS
1864: select invoice_amount
1865: from ap_invoices_all
1866: where invoice_id = p_document_id;
1867:
1868: CURSOR c_get_open_amount IS
1869: SELECT open_amt, original_line_amt

Line 2119: from ap_invoices_all apa

2115: ,apla.inventory_item_id inventory_item_id
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

Line 2909: from ap_invoices_all aia

2905: /*Addition of code by nprashar for bug # 7172723*/
2906: cursor c_get_source_type
2907: is
2908: select source
2909: from ap_invoices_all aia
2910: where aia.invoice_id in
2911: (select invoice_id
2912: from jai_rgm_Trx_refs refs
2913: where refs.reference_id = p_reference_id);

Line 2991: lr_source_type ap_invoices_all.source%type;

2987: lr_refs_rec c_get_refs_rec%rowtype;
2988: ln_doc_id number;
2989: ln_doc_line_id number;
2990: lv_trx_src jai_rgm_trx_records.source%type;
2991: lr_source_type ap_invoices_all.source%type;
2992: lr_doc_details c_get_doc_details%rowtype;
2993:
2994: begin
2995: