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_AP_TDS_GENERATION_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1300: lv_invoice_to_tds_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';

1296:
1297: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;
1298: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;
1299:
1300: lv_invoice_to_tds_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
1301: lv_invoice_to_vendor_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
1302:
1303: ln_invoice_to_tds_amount number;
1304: ln_invoice_to_vendor_amount number;

Line 1301: lv_invoice_to_vendor_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';

1297: ln_invoice_to_tds_line_id ap_invoice_lines_interface.invoice_line_id%type;
1298: ln_invoice_to_vendor_line_id ap_invoice_lines_interface.invoice_line_id%type;
1299:
1300: lv_invoice_to_tds_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
1301: lv_invoice_to_vendor_line_type ap_invoice_distributions_all.line_type_lookup_code%type; --File.Sql.35 Cbabu := 'ITEM';
1302:
1303: ln_invoice_to_tds_amount number;
1304: ln_invoice_to_vendor_amount number;
1305:

Line 1315: lv_open_period ap_invoice_distributions_all.period_name%type;

1311: lv_pay_group_lookup_code po_vendors.pay_group_lookup_code%type;
1312:
1313: lv_ja_in_ap_inv_id varchar2(15);
1314: ld_accounting_date date;
1315: lv_open_period ap_invoice_distributions_all.period_name%type;
1316: ln_tax_amount number;
1317:
1318: lv_invoice_num ap_invoices_all.invoice_num%type;
1319: lv_source_attribute jai_ap_tds_invoices.source_attribute%TYPE ; --rchandan for bug#4428980

Line 3188: FROM ap_invoice_distributions_all a,

3184: b.vendor_site_id,
3185: b.invoice_currency_code,
3186: b.exchange_rate,
3187: b.set_of_books_id
3188: FROM ap_invoice_distributions_all a,
3189: ap_invoices_all b
3190: WHERE a.invoice_id = b.invoice_id
3191: AND b.invoice_id = p_invoice_id
3192: AND a.line_type_lookup_code = 'PREPAY'

Line 3531: FROM ap_invoice_distributions_all

3527: FROM jai_ap_tds_thhold_trxs a
3528: WHERE a.tds_event = 'INVOICE VALIDATE'
3529: AND a.taxable_amount >= p_single_threshold_amt
3530: AND a.invoice_id IN (SELECT invoice_id
3531: FROM ap_invoice_distributions_all
3532: WHERE invoice_distribution_id = (SELECT prepay_distribution_id
3533: FROM ap_invoice_distributions_all
3534: WHERE invoice_distribution_id = p_invoice_distribution_id));
3535: lv_pp_flag VARCHAR2(1);

Line 3533: FROM ap_invoice_distributions_all

3529: AND a.taxable_amount >= p_single_threshold_amt
3530: AND a.invoice_id IN (SELECT invoice_id
3531: FROM ap_invoice_distributions_all
3532: WHERE invoice_distribution_id = (SELECT prepay_distribution_id
3533: FROM ap_invoice_distributions_all
3534: WHERE invoice_distribution_id = p_invoice_distribution_id));
3535: lv_pp_flag VARCHAR2(1);
3536:
3537: BEGIN