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 JAI_RGM_REGISTRATIONS

Line 145: cursor c_get_regime_attr_value (cp_attr_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE)

141: AND PVSA.ORG_ID = JATOTV.ORGANIZATION_ID
142: AND PV.VENDOR_ID = cp_vendor_id
143: AND PVSA.VENDOR_SITE_ID = cp_vendor_site_id;
144:
145: cursor c_get_regime_attr_value (cp_attr_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE)
146: is
147: SELECT jrr.ATTRIBUTE_VALUE
148: FROM JAI_RGM_DEFINITIONS jrd,
149: JAI_RGM_REGISTRATIONS jrr

Line 149: JAI_RGM_REGISTRATIONS jrr

145: cursor c_get_regime_attr_value (cp_attr_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE)
146: is
147: SELECT jrr.ATTRIBUTE_VALUE
148: FROM JAI_RGM_DEFINITIONS jrd,
149: JAI_RGM_REGISTRATIONS jrr
150: WHERE jrd.REGIME_ID = jrr.REGIME_ID
151: AND jrr.ATTRIBUTE_CODE = cp_attr_code
152: AND jrd.REGIME_CODE = 'TDS';
153: -- Added by Chong for bug#16281516 Start

Line 155: CURSOR c_get_ou_regime_value (cp_attr_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE

151: AND jrr.ATTRIBUTE_CODE = cp_attr_code
152: AND jrd.REGIME_CODE = 'TDS';
153: -- Added by Chong for bug#16281516 Start
154: -----------------------------------------------------
155: CURSOR c_get_ou_regime_value (cp_attr_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE
156: ,cp_org_id NUMBER
157: )
158: IS
159: SELECT jrorv.ATTRIBUTE_VALUE

Line 402: FROM JAI_RGM_REGISTRATIONS

398: AND JCDT.SOURCE_DOC_LINE_ID = cp_invoice_line_number
399: AND JCDT.SOURCE_DOC_TYPE = 'STANDALONE_INVOICE'
400: AND JCDT.TAX_ID = JCTA.TAX_ID
401: AND JCTA.TAX_TYPE IN (SELECT ATTRIBUTE_CODE
402: FROM JAI_RGM_REGISTRATIONS
403: WHERE REGIME_ID = (SELECT REGIME_ID
404: FROM JAI_RGM_DEFINITIONS
405: WHERE REGIME_CODE =JAI_CONSTANTS.SERVICE_REGIME)
406: AND REGISTRATION_TYPE = 'TAX_TYPES');

Line 418: FROM JAI_RGM_REGISTRATIONS

414: WHERE JAMIT.INVOICE_ID = p_inv_id
415: AND JAMIT.INVOICE_DISTRIBUTION_ID = cp_inv_dist_id
416: AND JAMIT.TAX_ID = JCTA.TAX_ID
417: AND JCTA.TAX_TYPE IN (SELECT ATTRIBUTE_CODE
418: FROM JAI_RGM_REGISTRATIONS
419: WHERE REGIME_ID = (SELECT REGIME_ID
420: FROM JAI_RGM_DEFINITIONS
421: WHERE REGIME_CODE =JAI_CONSTANTS.SERVICE_REGIME)
422: AND REGISTRATION_TYPE = 'TAX_TYPES');

Line 518: FROM JAI_RGM_REGISTRATIONS

514: AND JCT.TAX_ID = JAMIT.TAX_ID
515: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
516: AND JCT.TAX_TYPE
517: IN (SELECT ATTRIBUTE_CODE
518: FROM JAI_RGM_REGISTRATIONS
519: WHERE REGIME_ID = (SELECT REGIME_ID
520: FROM JAI_RGM_DEFINITIONS
521: WHERE REGIME_CODE ='SERVICE')
522: AND REGISTRATION_TYPE = 'TAX_TYPES');

Line 533: FROM JAI_RGM_REGISTRATIONS

529: AND JCT.TAX_ID = JAMIT.TAX_ID
530: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
531: AND JCT.TAX_TYPE
532: IN (SELECT ATTRIBUTE_CODE
533: FROM JAI_RGM_REGISTRATIONS
534: WHERE REGIME_ID = (SELECT REGIME_ID
535: FROM JAI_RGM_DEFINITIONS
536: WHERE REGIME_CODE ='SERVICE')
537: AND REGISTRATION_TYPE = 'TAX_TYPES');

Line 2196: FROM JAI_RGM_REGISTRATIONS

2192: AND JCT.TAX_ID = JAMIT.TAX_ID
2193: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2194: AND JCT.TAX_TYPE
2195: IN (SELECT ATTRIBUTE_CODE
2196: FROM JAI_RGM_REGISTRATIONS
2197: WHERE REGIME_ID = (SELECT REGIME_ID
2198: FROM JAI_RGM_DEFINITIONS
2199: WHERE REGIME_CODE ='SERVICE')
2200: AND REGISTRATION_TYPE = 'TAX_TYPES')

Line 2209: FROM JAI_RGM_REGISTRATIONS

2205: AND JCT.TAX_ID = JAMIT.TAX_ID
2206: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2207: AND JCT.TAX_TYPE
2208: IN (SELECT ATTRIBUTE_CODE
2209: FROM JAI_RGM_REGISTRATIONS
2210: WHERE REGIME_ID = (SELECT REGIME_ID
2211: FROM JAI_RGM_DEFINITIONS
2212: WHERE REGIME_CODE ='SERVICE')
2213: AND REGISTRATION_TYPE = 'TAX_TYPES')

Line 2262: FROM JAI_RGM_REGISTRATIONS

2258: AND JCT.TAX_ID = JAMIT.TAX_ID
2259: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2260: AND JCT.TAX_TYPE
2261: IN (SELECT ATTRIBUTE_CODE
2262: FROM JAI_RGM_REGISTRATIONS
2263: WHERE REGIME_ID = (SELECT REGIME_ID
2264: FROM JAI_RGM_DEFINITIONS
2265: WHERE REGIME_CODE ='SERVICE')
2266: AND REGISTRATION_TYPE = 'TAX_TYPES')

Line 2275: FROM JAI_RGM_REGISTRATIONS

2271: AND JCT.TAX_ID = JAMIT.TAX_ID
2272: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2273: AND JCT.TAX_TYPE
2274: IN (SELECT ATTRIBUTE_CODE
2275: FROM JAI_RGM_REGISTRATIONS
2276: WHERE REGIME_ID = (SELECT REGIME_ID
2277: FROM JAI_RGM_DEFINITIONS
2278: WHERE REGIME_CODE ='SERVICE')
2279: AND REGISTRATION_TYPE = 'TAX_TYPES')

Line 2323: FROM JAI_RGM_REGISTRATIONS

2319: AND JCT.TAX_ID = JAMIT.TAX_ID
2320: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2321: AND JCT.TAX_TYPE
2322: IN (SELECT ATTRIBUTE_CODE
2323: FROM JAI_RGM_REGISTRATIONS
2324: WHERE REGIME_ID = (SELECT REGIME_ID
2325: FROM JAI_RGM_DEFINITIONS
2326: WHERE REGIME_CODE ='SERVICE')
2327: AND REGISTRATION_TYPE = 'TAX_TYPES')

Line 2336: FROM JAI_RGM_REGISTRATIONS

2332: AND JCT.TAX_ID = JAMIT.TAX_ID
2333: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2334: AND JCT.TAX_TYPE
2335: IN (SELECT ATTRIBUTE_CODE
2336: FROM JAI_RGM_REGISTRATIONS
2337: WHERE REGIME_ID = (SELECT REGIME_ID
2338: FROM JAI_RGM_DEFINITIONS
2339: WHERE REGIME_CODE ='SERVICE')
2340: AND REGISTRATION_TYPE = 'TAX_TYPES')

Line 2391: FROM JAI_RGM_REGISTRATIONS

2387: AND JCT.TAX_ID = JAMIT.TAX_ID
2388: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2389: AND JCT.TAX_TYPE
2390: IN (SELECT ATTRIBUTE_CODE
2391: FROM JAI_RGM_REGISTRATIONS
2392: WHERE REGIME_ID = (SELECT REGIME_ID
2393: FROM JAI_RGM_DEFINITIONS
2394: WHERE REGIME_CODE ='SERVICE')
2395: AND REGISTRATION_TYPE = 'TAX_TYPES')

Line 2404: FROM JAI_RGM_REGISTRATIONS

2400: AND JCT.TAX_ID = JAMIT.TAX_ID
2401: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2402: AND JCT.TAX_TYPE
2403: IN (SELECT ATTRIBUTE_CODE
2404: FROM JAI_RGM_REGISTRATIONS
2405: WHERE REGIME_ID = (SELECT REGIME_ID
2406: FROM JAI_RGM_DEFINITIONS
2407: WHERE REGIME_CODE ='SERVICE')
2408: AND REGISTRATION_TYPE = 'TAX_TYPES')