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.JA_JAINER1_XMLP_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 1464: JAI_CMN_RG_23AC_I_TRXS JRGI,

1460: ,0)) DUTY_PAYABLE,
1461: SUM(NVL(JRGI.ADDITIONAL_ED
1462: ,0)) AED_DUTY_PAYABLE
1463: FROM
1464: JAI_CMN_RG_23AC_I_TRXS JRGI,
1465: JAI_INV_ITM_SETUPS ITEMS
1466: WHERE JRGI.TRANSACTION_TYPE in ( 'RTV' , 'I' , 'IA' , 'IOI' , 'PI' )
1467: AND ( JRGI.INVENTORY_ITEM_ID = cf_duty_payableformula.INVENTORY_ITEM_ID
1468: OR ITEMS.ITEM_TARIFF = CETSH )

Line 1589: JAI_CMN_RG_23AC_I_TRXS JRGI,

1585: WHERE SOURCE_REGISTER_ID IN (
1586: SELECT
1587: REGISTER_ID_PART_II
1588: FROM
1589: JAI_CMN_RG_23AC_I_TRXS JRGI,
1590: JAI_INV_ITM_SETUPS ITEMS
1591: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_other_dutiesformula.INVENTORY_ITEM_ID
1592: OR ITEMS.ITEM_TARIFF = CETSH )
1593: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID

Line 1616: JAI_CMN_RG_23AC_I_TRXS JRGI,

1612: WHERE SOURCE_REGISTER_ID IN (
1613: SELECT
1614: REGISTER_ID_PART_II
1615: FROM
1616: JAI_CMN_RG_23AC_I_TRXS JRGI,
1617: JAI_INV_ITM_SETUPS ITEMS
1618: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_other_dutiesformula.INVENTORY_ITEM_ID
1619: OR ITEMS.ITEM_TARIFF = CETSH )
1620: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID

Line 2292: JAI_CMN_RG_23AC_I_TRXS JRG23_I

2288: ,0) + NVL(JRG23_II.DR_OTHER_ED
2289: ,0))
2290: FROM
2291: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
2292: JAI_CMN_RG_23AC_I_TRXS JRG23_I
2293: WHERE JRG23_II.ORGANIZATION_ID = P_ORGANIZATION_ID
2294: AND JRG23_II.LOCATION_ID = P_LOCATION_ID
2295: AND TRUNC(JRG23_II.CREATION_DATE) >= P_START_DATE
2296: AND TRUNC(JRG23_II.CREATION_DATE) <= TRUNC(NVL(P_END_DATE

Line 2310: JAI_CMN_RG_23AC_I_TRXS JRG23_I,

2306: ,0) + NVL(JRG23_II.DR_OTHER_ED
2307: ,0))
2308: FROM
2309: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
2310: JAI_CMN_RG_23AC_I_TRXS JRG23_I,
2311: JAI_INV_ITM_SETUPS JMSI
2312: WHERE JRG23_II.ORGANIZATION_ID = JRG23_I.ORGANIZATION_ID
2313: AND JRG23_II.LOCATION_ID = JRG23_I.LOCATION_ID
2314: AND JRG23_II.REGISTER_ID_PART_I = JRG23_I.REGISTER_ID

Line 2369: JAI_CMN_RG_23AC_I_TRXS JRG23_I

2365: SELECT
2366: JRG23_II.REGISTER_ID
2367: FROM
2368: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
2369: JAI_CMN_RG_23AC_I_TRXS JRG23_I
2370: WHERE JRG23_II.ORGANIZATION_ID = P_ORGANIZATION_ID
2371: AND JRG23_II.LOCATION_ID = P_LOCATION_ID
2372: AND TRUNC(JRG23_II.CREATION_DATE) >= P_START_DATE
2373: AND TRUNC(JRG23_II.CREATION_DATE) <= TRUNC(NVL(P_END_DATE

Line 2392: JAI_CMN_RG_23AC_I_TRXS JRG23_I,

2388: SELECT
2389: JRG23_II.REGISTER_ID
2390: FROM
2391: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
2392: JAI_CMN_RG_23AC_I_TRXS JRG23_I,
2393: JAI_INV_ITM_SETUPS JMSI
2394: WHERE JRG23_II.ORGANIZATION_ID = JRG23_I.ORGANIZATION_ID
2395: AND JRG23_II.LOCATION_ID = JRG23_I.LOCATION_ID
2396: AND JRG23_II.REGISTER_ID_PART_I = JRG23_I.REGISTER_ID

Line 3100: JAI_CMN_RG_23AC_I_TRXS JRG23_I

3096: SELECT
3097: JRG23_II.REGISTER_ID
3098: FROM
3099: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
3100: JAI_CMN_RG_23AC_I_TRXS JRG23_I
3101: WHERE JRG23_II.ORGANIZATION_ID = P_ORGANIZATION_ID
3102: AND JRG23_II.LOCATION_ID = P_LOCATION_ID
3103: AND TRUNC(JRG23_II.CREATION_DATE) >= P_START_DATE
3104: AND TRUNC(JRG23_II.CREATION_DATE) <= TRUNC(NVL(P_END_DATE

Line 3123: JAI_CMN_RG_23AC_I_TRXS JRG23_I,

3119: SELECT
3120: JRG23_II.REGISTER_ID
3121: FROM
3122: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
3123: JAI_CMN_RG_23AC_I_TRXS JRG23_I,
3124: JAI_INV_ITM_SETUPS JMSI
3125: WHERE JRG23_II.ORGANIZATION_ID = JRG23_I.ORGANIZATION_ID
3126: AND JRG23_II.LOCATION_ID = JRG23_I.LOCATION_ID
3127: AND JRG23_II.REGISTER_ID_PART_I = JRG23_I.REGISTER_ID

Line 3462: JAI_CMN_RG_23AC_I_TRXS JRGI,

3458: WHERE SOURCE_REGISTER_ID IN (
3459: SELECT
3460: REGISTER_ID_PART_II
3461: FROM
3462: JAI_CMN_RG_23AC_I_TRXS JRGI,
3463: JAI_INV_ITM_SETUPS ITEMS
3464: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_sh_other_dutiesformula.INVENTORY_ITEM_ID
3465: OR ITEMS.ITEM_TARIFF = CETSH )
3466: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID

Line 3489: JAI_CMN_RG_23AC_I_TRXS JRGI,

3485: WHERE SOURCE_REGISTER_ID IN (
3486: SELECT
3487: REGISTER_ID_PART_II
3488: FROM
3489: JAI_CMN_RG_23AC_I_TRXS JRGI,
3490: JAI_INV_ITM_SETUPS ITEMS
3491: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_sh_other_dutiesformula.INVENTORY_ITEM_ID
3492: OR ITEMS.ITEM_TARIFF = CETSH )
3493: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID