eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 241: FROM ap_invoice_distributions_all

237: WHERE receivable_application_id = pn_source_document_id;
238:
239: CURSOR get_dist_date_cur IS
240: SELECT accounting_date
241: FROM ap_invoice_distributions_all
242: WHERE invoice_distribution_id = pn_source_document_id;
243:
244: CURSOR get_ar_dist_date_cur IS
245: SELECT gl_date

Line 326: FROM ap_invoice_distributions_all

322: AND ail.line_number = pv_document_line_id;
323:
324: CURSOR get_discarded_dist_date_cur IS
325: SELECT accounting_date
326: FROM ap_invoice_distributions_all
327: WHERE invoice_id = pn_document_id
328: AND invoice_line_number = pv_document_line_id
329: AND nvl(reversal_flag,'N') = 'Y'
330: AND parent_reversal_id IS NOT NULL;

Line 348: if pv_source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL' then

344: FETCH c_get_st_accrual_date INTO ld_pot_date;
345: CLOSE c_get_st_accrual_date;
346:
347: IF pv_source = 'AP' THEN
348: if pv_source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL' then
349: OPEN get_dist_date_cur;
350: FETCH get_dist_date_cur INTO ld_gl_date;
351: CLOSE get_dist_date_cur;
352:

Line 689: from ap_invoice_distributions_all

685: from
686: (select
687: INVOICE_DISTRIBUTION_ID inv_dist_id,
688: row_number() over(ORDER BY INVOICE_DISTRIBUTION_ID) line_num
689: from ap_invoice_distributions_all
690: where INVOICE_ID=p_invoice_id
691: )
692: where inv_dist_id=p_line_id;
693:

Line 695: lr_inv_dist_id ap_invoice_distributions_all.INVOICE_DISTRIBUTION_ID%type;

691: )
692: where inv_dist_id=p_line_id;
693:
694: lr_line_number number;
695: lr_inv_dist_id ap_invoice_distributions_all.INVOICE_DISTRIBUTION_ID%type;
696: --Add by Wenqiong for Advanced Receipt begin
697: -------------------------------------------------
698: ln_refer_invoice_id NUMBER;
699: ln_refer_item_line_id NUMBER;

Line 2081: FROM ap_invoice_distributions_all aida,

2077: and msl.organization_id = p_organization_id;
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

Line 2122: , ap_invoice_distributions_all aida

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
2125: AND aida.invoice_id = p_document_id
2126: AND aida.invoice_distribution_id = p_document_line_id

Line 2131: lr_dist_detail ap_invoice_distributions_all%ROWTYPE;

2127: AND apa.invoice_id = apla.invoice_id
2128: AND apla.line_number = aida.invoice_line_number
2129: AND pov.vendor_id = apa.vendor_id ;
2130:
2131: lr_dist_detail ap_invoice_distributions_all%ROWTYPE;
2132: ln_organization_id NUMBER;
2133: ln_location_id NUMBER;
2134: ln_line_number NUMBER;
2135: lv_match_type VARCHAR2(30);

Line 2185: FROM ap_invoice_distributions_all

2181: -- Added by Chong.Lei for POT code port end
2182:
2183: CURSOR get_ap_gl_date_cur(cp_line_num NUMBER) IS
2184: SELECT accounting_date
2185: FROM ap_invoice_distributions_all
2186: WHERE invoice_id = p_document_id
2187: AND invoice_line_number = cp_line_num;
2188:
2189: CURSOR get_ar_gl_date_cur IS

Line 2923: from ap_invoice_distributions_all

2919: from
2920: (select
2921: INVOICE_DISTRIBUTION_ID inv_dist_id,
2922: row_number() over(ORDER BY INVOICE_DISTRIBUTION_ID) line_num
2923: from ap_invoice_distributions_all
2924: where INVOICE_ID=p_invoice_id
2925: )
2926: where inv_dist_id=p_line_id;
2927:

Line 2929: lr_inv_dist_id ap_invoice_distributions_all.INVOICE_DISTRIBUTION_ID%type;

2925: )
2926: where inv_dist_id=p_line_id;
2927:
2928: lr_line_number number;
2929: lr_inv_dist_id ap_invoice_distributions_all.INVOICE_DISTRIBUTION_ID%type;
2930:
2931: cursor c_get_doc_details(p_invoice_id jai_rgm_trx_refs.invoice_id%type,p_row_number number)
2932: is
2933: SELECT shipment_header_id,

Line 3357: cursor c_get_po_reference (cp_invoice_id ap_invoice_distributions_all.invoice_id%type

3353: and rctl.customer_trx_line_id = cp_customer_trx_line_id;
3354:
3355: lr_inv_attr c_chk_ar_inv_attr%rowtype;
3356:
3357: cursor c_get_po_reference (cp_invoice_id ap_invoice_distributions_all.invoice_id%type
3358: ,cp_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type
3359: )
3360: is
3361: select pod.po_header_id

Line 3358: ,cp_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type

3354:
3355: lr_inv_attr c_chk_ar_inv_attr%rowtype;
3356:
3357: cursor c_get_po_reference (cp_invoice_id ap_invoice_distributions_all.invoice_id%type
3358: ,cp_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type
3359: )
3360: is
3361: select pod.po_header_id
3362: ,pod.po_line_id

Line 3365: ,ap_invoice_distributions_all apd

3361: select pod.po_header_id
3362: ,pod.po_line_id
3363: ,apd.rcv_transaction_id /*Added by vkantamn for Bug#6083978*/
3364: from po_distributions_all pod
3365: ,ap_invoice_distributions_all apd
3366: where pod.po_distribution_id = apd.po_distribution_id
3367: and apd.invoice_id = cp_invoice_id
3368: and apd.invoice_distribution_id = cp_distribution_id;
3369:

Line 3640: ,ap_invoice_distributions_all apd

3636: select recs.service_type_code
3637: from jai_rgm_trx_records recs
3638: ,jai_rgm_trx_refs refs
3639: ,po_distributions_all pod
3640: ,ap_invoice_distributions_all apd
3641: where pod.po_line_id = p_document_line_id
3642: and pod.po_distribution_id = apd.po_distribution_id
3643: and apd.invoice_distribution_id = refs.item_line_id
3644: and recs.reference_id = refs.reference_id