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_ETDS_PKG dependencies on AP_CHECKS_V

Line 604: FROM ap_invoice_payments_all PAY, ap_checks_all APC \* renamed the table from ap_checks_v to ap_checks_All for bug 12691784*\, JAI_AP_TDS_PAYMENTS JATP

600: \*Modified the cursor c_tds_payment_check_id by JMEENA for bug#4600778 to select the bsr_code from JAI_AP_TDS_PAYMENTS table *\
601: CURSOR c_tds_payment_check_id(p_invoice_id IN NUMBER) IS
602: SELECT pay.check_id, apc.bank_account_name, JATP.Challan_no challan_num,
603: JATP.check_deposit_date challan_date, JATP.bsr_code branch_code, apc.check_number check_number \*Bug 7688789 - Added Check Number*\
604: FROM ap_invoice_payments_all PAY, ap_checks_all APC \* renamed the table from ap_checks_v to ap_checks_All for bug 12691784*\, JAI_AP_TDS_PAYMENTS JATP
605: WHERE PAY.invoice_id = p_invoice_id
606: AND PAY.check_id = APC.check_id
607: AND APC.check_id = JATP.check_id
608: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);

Line 614: FROM ap_invoice_payments_all PAY, ap_checks_all APC\renamed the table from ap_checks_v to ap_checks_All for Bug 12691784\, JAI_AP_TDS_PAYMENTS JATP

610: \*Bug 12415388 - Get Payment details based on CHECK_ID instead of TDS_INVOICE_ID as a single TDS Invoice may be paid with multiple checks*\
611: CURSOR c_tds_payment_details(p_check_id IN NUMBER) IS
612: SELECT pay.check_id, apc.bank_account_name, JATP.Challan_no challan_num,
613: JATP.check_deposit_date challan_date, JATP.bsr_code branch_code, apc.check_number check_number \*Bug 7688789 - Added Check Number*\
614: FROM ap_invoice_payments_all PAY, ap_checks_all APC\*renamed the table from ap_checks_v to ap_checks_All for Bug 12691784*\, JAI_AP_TDS_PAYMENTS JATP
615: WHERE PAY.check_id = p_check_id
616: AND PAY.check_id = APC.check_id
617: AND APC.check_id = JATP.check_id
618: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);

Line 622: FROM ap_invoice_payments_all PAY, ap_checks_v APC

618: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);
619:
620: CURSOR c_base_payment_check_id(p_invoice_id IN NUMBER) IS
621: SELECT pay.check_id, apc.current_bank_account_name, check_date
622: FROM ap_invoice_payments_all PAY, ap_checks_v APC
623: WHERE PAY.invoice_id = p_invoice_id
624: AND PAY.check_id = APC.check_id
625: AND APC.status_lookup_code NOT IN (lv_voided, lv_stop_init);
626:

Line 1855: FROM ap_invoice_payments_all PAY, ap_checks_all APC /* renamed the table from ap_checks_v to ap_checks_All for bug 12691784*/, JAI_AP_TDS_PAYMENTS JATP

1851: /*Modified the cursor c_tds_payment_check_id by JMEENA for bug#4600778 to select the bsr_code from JAI_AP_TDS_PAYMENTS table */
1852: CURSOR c_tds_payment_check_id(p_invoice_id IN NUMBER) IS
1853: SELECT pay.check_id, apc.bank_account_name, JATP.Challan_no challan_num,
1854: JATP.check_deposit_date challan_date, JATP.bsr_code branch_code, apc.check_number check_number /*Bug 7688789 - Added Check Number*/
1855: FROM ap_invoice_payments_all PAY, ap_checks_all APC /* renamed the table from ap_checks_v to ap_checks_All for bug 12691784*/, JAI_AP_TDS_PAYMENTS JATP
1856: WHERE PAY.invoice_id = p_invoice_id
1857: AND PAY.check_id = APC.check_id
1858: AND APC.check_id = JATP.check_id
1859: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);

Line 1865: FROM ap_invoice_payments_all PAY, ap_checks_all APC/renamed the table from ap_checks_v to ap_checks_All for Bug 12691784/, JAI_AP_TDS_PAYMENTS JATP

1861: /*Bug 12415388 - Get Payment details based on CHECK_ID instead of TDS_INVOICE_ID as a single TDS Invoice may be paid with multiple checks*/
1862: CURSOR c_tds_payment_details(p_check_id IN NUMBER) IS
1863: SELECT pay.check_id, apc.bank_account_name, JATP.Challan_no challan_num,
1864: JATP.check_deposit_date challan_date, JATP.bsr_code branch_code, apc.check_number check_number /*Bug 7688789 - Added Check Number*/
1865: FROM ap_invoice_payments_all PAY, ap_checks_all APC/*renamed the table from ap_checks_v to ap_checks_All for Bug 12691784*/, JAI_AP_TDS_PAYMENTS JATP
1866: WHERE PAY.check_id = p_check_id
1867: AND PAY.check_id = APC.check_id
1868: AND APC.check_id = JATP.check_id
1869: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);

Line 1873: FROM ap_invoice_payments_all PAY, ap_checks_v APC

1869: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);
1870:
1871: CURSOR c_base_payment_check_id(p_invoice_id IN NUMBER) IS
1872: SELECT pay.check_id, apc.current_bank_account_name, check_date
1873: FROM ap_invoice_payments_all PAY, ap_checks_v APC
1874: WHERE PAY.invoice_id = p_invoice_id
1875: AND PAY.check_id = APC.check_id
1876: AND APC.status_lookup_code NOT IN (lv_voided, lv_stop_init);
1877: