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_BOE_MIGRATION_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 837: FROM jai_cmn_tax_ctg_lines jctl,

833: ,xn_tax_id OUT NOCOPY NUMBER
834: ) IS
835: CURSOR tax_cnt_cur(v_tax_category_id NUMBER, v_tax_type VARCHAR2) IS
836: SELECT count(b.tax_id) cnt_tax
837: FROM jai_cmn_tax_ctg_lines jctl,
838: jai_cmn_taxes_all b
839: WHERE jctl.tax_category_id = v_tax_category_id
840: AND jctl.tax_id = b.tax_id
841: AND b.tax_type = v_tax_type;

Line 845: FROM jai_cmn_tax_ctg_lines jctl,

841: AND b.tax_type = v_tax_type;
842: CURSOR tax_cur(v_tax_category_id NUMBER, v_tax_type VARCHAR2) IS
843: SELECT b.tax_id,
844: b.tax_name
845: FROM jai_cmn_tax_ctg_lines jctl,
846: jai_cmn_taxes_all b
847: WHERE jctl.tax_category_id = v_tax_category_id
848: AND jctl.tax_id = b.tax_id
849: AND b.tax_type = v_tax_type;

Line 1243: jai_cmn_tax_ctg_lines jctl,

1239: SELECT jitc.tax_category_id,
1240: jctl.tax_id, b.tax_type,
1241: rttv.regime_code
1242: FROM jai_cmn_tax_ctgs_all jitc,
1243: jai_cmn_tax_ctg_lines jctl,
1244: jai_cmn_taxes_all b,
1245: jai_regime_tax_types_v rttv
1246: WHERE jitc.tax_category_id = jctl.tax_category_id
1247: AND jctl.tax_id = b.tax_id

Line 1256: jai_cmn_tax_ctg_lines jctl,

1252: SELECT jitc.tax_category_id,
1253: b.tax_type,
1254: COUNT(jctl.tax_id) cnt_tax_id
1255: FROM jai_cmn_tax_ctgs_all jitc,
1256: jai_cmn_tax_ctg_lines jctl,
1257: jai_cmn_taxes_all b,
1258: jai_regime_tax_types_v rttv
1259: WHERE jitc.tax_category_id = jctl.tax_category_id
1260: AND jctl.tax_id = b.tax_id