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_DTC_DEFAULTATION_PKG dependencies on AP_INVOICES_ALL

Line 114: AP_INVOICES_ALL aia

110: is
111: SELECT aia.VENDOR_ID,
112: jatvh.TDS_VENDOR_TYPE_LOOKUP_CODE
113: FROM JAI_AP_TDS_VENDOR_HDRS jatvh,
114: AP_INVOICES_ALL aia
115: WHERE aia.VENDOR_ID = jatvh.VENDOR_ID
116: AND aia.INVOICE_ID = p_inv_id;
117:
118: -- cursor to get information (Operating Unit ID, Legal Entity ID, Ledger ID)from ap invoices

Line 126: FROM AP_INVOICES_ALL

122: LEGAL_ENTITY_ID,
123: SET_OF_BOOKS_ID,
124: INVOICE_TYPE_LOOKUP_CODE,
125: VENDOR_SITE_ID
126: FROM AP_INVOICES_ALL
127: WHERE INVOICE_ID = p_inv_id;
128:
129: -- cursor to get pan number and tan number
130: cursor c_get_vendor_pan_tan(cp_vendor_id number , cp_vendor_site_id number) is

Line 203: FROM AP_INVOICES_ALL

199: WHERE INVOICE_ID = p_inv_id
200: AND LINE_TYPE_LOOKUP_CODE NOT IN
201: ('PREPAY', 'TIPV', 'TERV', 'TAX', 'MISCELLANEOUS')
202: AND NOT EXISTS (SELECT '1'
203: FROM AP_INVOICES_ALL
204: WHERE INVOICE_ID = p_inv_id
205: AND SOURCE = 'INDIA TDS')
206: UNION
207: SELECT INVOICE_ID,

Line 236: FROM AP_INVOICES_ALL

232: JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
233: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS,
234: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS))
235: AND NOT EXISTS (SELECT '1'
236: FROM AP_INVOICES_ALL
237: WHERE INVOICE_ID = p_inv_id
238: AND SOURCE = 'INDIA TDS')
239: ORDER BY INVOICE_DISTRIBUTION_ID;
240:

Line 729: ln_vendor_site_id AP_INVOICES_ALL.VENDOR_SITE_ID%TYPE;

725:
726: -- variables
727: ln_vendor_id JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE;
728: lv_vendor_type JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE;
729: ln_vendor_site_id AP_INVOICES_ALL.VENDOR_SITE_ID%TYPE;
730: ln_org_id AP_INVOICES_ALL.ORG_ID%TYPE;
731: ln_legal_entity_id AP_INVOICES_ALL.LEGAL_ENTITY_ID%TYPE;
732: ln_ledger_id AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE;
733: lv_inv_tlc AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

Line 730: ln_org_id AP_INVOICES_ALL.ORG_ID%TYPE;

726: -- variables
727: ln_vendor_id JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE;
728: lv_vendor_type JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE;
729: ln_vendor_site_id AP_INVOICES_ALL.VENDOR_SITE_ID%TYPE;
730: ln_org_id AP_INVOICES_ALL.ORG_ID%TYPE;
731: ln_legal_entity_id AP_INVOICES_ALL.LEGAL_ENTITY_ID%TYPE;
732: ln_ledger_id AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE;
733: lv_inv_tlc AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
734: lv_segment_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;

Line 731: ln_legal_entity_id AP_INVOICES_ALL.LEGAL_ENTITY_ID%TYPE;

727: ln_vendor_id JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE;
728: lv_vendor_type JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE;
729: ln_vendor_site_id AP_INVOICES_ALL.VENDOR_SITE_ID%TYPE;
730: ln_org_id AP_INVOICES_ALL.ORG_ID%TYPE;
731: ln_legal_entity_id AP_INVOICES_ALL.LEGAL_ENTITY_ID%TYPE;
732: ln_ledger_id AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE;
733: lv_inv_tlc AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
734: lv_segment_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
735: ld_max_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE;

Line 732: ln_ledger_id AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE;

728: lv_vendor_type JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE;
729: ln_vendor_site_id AP_INVOICES_ALL.VENDOR_SITE_ID%TYPE;
730: ln_org_id AP_INVOICES_ALL.ORG_ID%TYPE;
731: ln_legal_entity_id AP_INVOICES_ALL.LEGAL_ENTITY_ID%TYPE;
732: ln_ledger_id AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE;
733: lv_inv_tlc AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
734: lv_segment_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
735: ld_max_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE;
736: ld_min_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE;

Line 733: lv_inv_tlc AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

729: ln_vendor_site_id AP_INVOICES_ALL.VENDOR_SITE_ID%TYPE;
730: ln_org_id AP_INVOICES_ALL.ORG_ID%TYPE;
731: ln_legal_entity_id AP_INVOICES_ALL.LEGAL_ENTITY_ID%TYPE;
732: ln_ledger_id AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE;
733: lv_inv_tlc AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
734: lv_segment_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
735: ld_max_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE;
736: ld_min_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE;
737: ln_max_period_year GL_PERIODS.PERIOD_YEAR%TYPE;

Line 2217: FROM AP_INVOICES_ALL

2213: AND REGISTRATION_TYPE = 'TAX_TYPES')
2214: )
2215: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.
2216: AND NOT EXISTS (SELECT '1'
2217: FROM AP_INVOICES_ALL
2218: WHERE INVOICE_ID = cp_inv_id
2219: AND SOURCE = 'INDIA TDS')
2220: UNION
2221: SELECT INVOICE_ID,

Line 2283: FROM AP_INVOICES_ALL

2279: AND REGISTRATION_TYPE = 'TAX_TYPES')
2280: )
2281: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.
2282: AND NOT EXISTS (SELECT '1'
2283: FROM AP_INVOICES_ALL
2284: WHERE INVOICE_ID = cp_inv_id
2285: AND SOURCE = 'INDIA TDS')
2286: ORDER BY INVOICE_DISTRIBUTION_ID;
2287: Commented by Chong for bug#16367707 End*/

Line 2344: FROM AP_INVOICES_ALL

2340: AND REGISTRATION_TYPE = 'TAX_TYPES')
2341: )
2342: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.
2343: AND NOT EXISTS (SELECT '1'
2344: FROM AP_INVOICES_ALL
2345: WHERE INVOICE_ID = cp_inv_id
2346: AND SOURCE = 'INDIA TDS')
2347: UNION
2348: SELECT AIDA.INVOICE_ID,

Line 2412: FROM AP_INVOICES_ALL

2408: AND REGISTRATION_TYPE = 'TAX_TYPES')
2409: )
2410: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.
2411: AND NOT EXISTS (SELECT '1'
2412: FROM AP_INVOICES_ALL
2413: WHERE INVOICE_ID = cp_inv_id
2414: AND SOURCE = 'INDIA TDS')
2415: ORDER BY INVOICE_DISTRIBUTION_ID;
2416: -------------------------------------------------------------------------