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_INVOICE_DISTRIBUTIONS_ALL

Line 172: FROM AP_INVOICE_DISTRIBUTIONS_ALL

168: cursor c_get_accounting_date
169: is
170: SELECT MAX(ACCOUNTING_DATE) MAX_DATE,
171: MIN(ACCOUNTING_DATE) MIN_DATE
172: FROM AP_INVOICE_DISTRIBUTIONS_ALL
173: WHERE INVOICE_ID = p_inv_id;
174:
175: -- cursor to get period year from gl_periods
176: cursor c_get_period_year(cp_calendar_id number,

Line 177: cp_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE)

173: WHERE INVOICE_ID = p_inv_id;
174:
175: -- cursor to get period year from gl_periods
176: cursor c_get_period_year(cp_calendar_id number,
177: cp_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE)
178: is
179: SELECT a.PERIOD_YEAR
180: FROM GL_PERIODS a, gl_period_sets b
181: WHERE a.PERIOD_SET_NAME = b.period_set_name

Line 198: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA

194: DESCRIPTION,
195: MATCH_STATUS_FLAG,
196: LINE_TYPE_LOOKUP_CODE,
197: ACCOUNTING_DATE
198: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA
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'

Line 217: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA

213: DESCRIPTION,
214: MATCH_STATUS_FLAG,
215: LINE_TYPE_LOOKUP_CODE,
216: ACCOUNTING_DATE
217: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA
218: WHERE INVOICE_ID = p_inv_id
219: AND LINE_TYPE_LOOKUP_CODE IN ('MISCELLANEOUS')
220: AND NOT EXISTS
221: (SELECT '1'

Line 436: FROM AP_INVOICE_DISTRIBUTIONS_ALL aida,

432: -- cursor to get parent distribution id for standardalone
433: cursor c_get_standalone_dist_id
434: is
435: SELECT aida.INVOICE_DISTRIBUTION_ID
436: FROM AP_INVOICE_DISTRIBUTIONS_ALL aida,
437: JAI_CMN_DOCUMENT_TAXES jcdt
438: WHERE jcdt.SOURCE_DOC_ID = p_inv_id
439: AND aida.INVOICE_LINE_NUMBER = jcdt.SOURCE_DOC_PARENT_LINE_NO
440: ORDER BY aida.INVOICE_DISTRIBUTION_ID;

Line 502: FROM AP_INVOICE_DISTRIBUTIONS_ALL

498: -- cursor to get code combination id
499: cursor c_get_dist_ccid (cp_inv_dist_id number)
500: is
501: SELECT DIST_CODE_COMBINATION_ID
502: FROM AP_INVOICE_DISTRIBUTIONS_ALL
503: WHERE INVOICE_ID = p_inv_id
504: AND INVOICE_DISTRIBUTION_ID = cp_inv_dist_id;
505:
506: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin

Line 735: ld_max_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%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;
738: ln_min_period_year GL_PERIODS.PERIOD_YEAR%TYPE;
739: lv_tax_default_option VARCHAR2(40);

Line 736: ld_min_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%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;
738: ln_min_period_year GL_PERIODS.PERIOD_YEAR%TYPE;
739: lv_tax_default_option VARCHAR2(40);
740: lv_tds_vendor_default_flag VARCHAR2(40) := NULL; --Added by Chong for bug#16367707

Line 2180: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA

2176: DESCRIPTION,
2177: MATCH_STATUS_FLAG,
2178: LINE_TYPE_LOOKUP_CODE,
2179: ACCOUNTING_DATE
2180: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA
2181: WHERE INVOICE_ID = cp_inv_id
2182: AND LINE_TYPE_LOOKUP_CODE NOT IN
2183: ('PREPAY', 'TIPV', 'TERV', 'TAX', 'MISCELLANEOUS')
2184: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin

Line 2232: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA

2228: DESCRIPTION,
2229: MATCH_STATUS_FLAG,
2230: LINE_TYPE_LOOKUP_CODE,
2231: ACCOUNTING_DATE
2232: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA
2233: WHERE INVOICE_ID = cp_inv_id
2234: AND LINE_TYPE_LOOKUP_CODE IN ('MISCELLANEOUS')
2235: AND NOT EXISTS
2236: (SELECT '1'

Line 2306: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA

2302: AIDA.DESCRIPTION,
2303: AIDA.MATCH_STATUS_FLAG,
2304: AIDA.LINE_TYPE_LOOKUP_CODE,
2305: AIDA.ACCOUNTING_DATE
2306: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA
2307: ,PO_DISTRIBUTIONS_ALL PDA
2308: WHERE AIDA.INVOICE_ID = cp_inv_id
2309: AND AIDA.PO_DISTRIBUTION_ID = PDA.PO_DISTRIBUTION_ID(+) --Added by Chong for bug#16367707
2310: AND AIDA.LINE_TYPE_LOOKUP_CODE NOT IN

Line 2359: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA

2355: AIDA.DESCRIPTION,
2356: AIDA.MATCH_STATUS_FLAG,
2357: AIDA.LINE_TYPE_LOOKUP_CODE,
2358: AIDA.ACCOUNTING_DATE
2359: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA
2360: ,PO_DISTRIBUTIONS_ALL PDA
2361: WHERE AIDA.INVOICE_ID = cp_inv_id
2362: AND AIDA.PO_DISTRIBUTION_ID = PDA.PO_DISTRIBUTION_ID(+) --Added by Chong for bug#16367707
2363: AND AIDA.LINE_TYPE_LOOKUP_CODE IN ('MISCELLANEOUS')

Line 2444: FROM AP_INVOICE_DISTRIBUTIONS_ALL aida,

2440: -- PRAGMA AUTONOMOUS_TRANSACTION; --commented by Cholei for ZX integration bug#14040855
2441: begin
2442: begin
2443: SELECT aida.INVOICE_DISTRIBUTION_ID INTO cp_inv_dist_id
2444: FROM AP_INVOICE_DISTRIBUTIONS_ALL aida,
2445: JAI_CMN_DOCUMENT_TAXES jcdt
2446: WHERE jcdt.SOURCE_DOC_ID = cp_inv_id
2447: AND jcdt.SOURCE_DOC_LINE_ID = cp_inv_line_number -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012
2448: AND jcdt.SOURCE_DOC_ID = aida.INVOICE_ID

Line 2466: FROM AP_INVOICE_DISTRIBUTIONS_ALL

2462: begin
2463: SELECT MAX(ACCOUNTING_DATE) MAX_DATE,
2464: MIN(ACCOUNTING_DATE) MIN_DATE
2465: INTO cp_max_date, cp_min_date
2466: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2467: WHERE INVOICE_ID = cp_inv_id;
2468: EXCEPTION
2469: WHEN NO_DATA_FOUND THEN
2470: cp_max_date := null;

Line 2483: FROM AP_INVOICE_DISTRIBUTIONS_ALL

2479: -- PRAGMA AUTONOMOUS_TRANSACTION; --commented by Cholei for ZX integration bug#14040855
2480: begin
2481: begin
2482: SELECT DIST_CODE_COMBINATION_ID into cp_parent_dist_ccid
2483: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2484: WHERE INVOICE_ID = cp_inv_id
2485: AND INVOICE_DISTRIBUTION_ID = cp_inv_dist_id;
2486: EXCEPTION
2487: WHEN NO_DATA_FOUND THEN