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.

[Home] [Help]

APPS.JA_JAINER1_XMLP_PKG dependencies on JAI_INV_ITM_SETUPS

Line 70: JAI_INV_ITM_SETUPS C

66: ,0)
67: INTO LN_BASIC_ED
68: FROM
69: JAI_CMN_RG_I_TRXS A,
70: JAI_INV_ITM_SETUPS C
71: WHERE A.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID
72: AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
73: AND ( C.ITEM_TARIFF = CETSH
74: OR A.INVENTORY_ITEM_ID = cf_cenvat_dutyformula.INVENTORY_ITEM_ID )

Line 190: JAI_INV_ITM_SETUPS C

186: INTO LN_CR_BASIC_ED
187: FROM
188: JAI_CMN_RG_I_TRXS A,
189: MTL_SYSTEM_ITEMS B,
190: JAI_INV_ITM_SETUPS C
191: WHERE A.TRANSACTION_TYPE in ( 'I' , 'IA' , 'IOI' , 'PI' )
192: AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
193: AND C.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
194: AND C.ORGANIZATION_ID = B.ORGANIZATION_ID

Line 1311: JAI_INV_ITM_SETUPS ITEMS

1307: ,0)) QTY_MANUFACTURED
1308: INTO LN_QTY_MFTRD
1309: FROM
1310: JAI_CMN_RG_I_TRXS JRGI,
1311: JAI_INV_ITM_SETUPS ITEMS
1312: WHERE JRGI.TRANSACTION_TYPE in ( 'R' , 'PR' , 'RA' , 'IOR' , 'CR' )
1313: AND ( JRGI.INVENTORY_ITEM_ID = CF_1FORMULA.INVENTORY_ITEM_ID
1314: OR NVL(ITEMS.ITEM_TARIFF
1315: ,'xyz') = NVL(CETSH

Line 1361: JAI_INV_ITM_SETUPS ITEMS

1357: ,0)) QTY_MANUFACTURED
1358: INTO LN_QTY_CLRD
1359: FROM
1360: JAI_CMN_RG_I_TRXS JRGI,
1361: JAI_INV_ITM_SETUPS ITEMS
1362: WHERE JRGI.TRANSACTION_TYPE in ( 'I' , 'IA' , 'PI' , 'IOI' )
1363: AND ( JRGI.INVENTORY_ITEM_ID = CF_QTY_CLEAREDFORMULA.INVENTORY_ITEM_ID
1364: OR NVL(ITEMS.ITEM_TARIFF
1365: ,'xyz') = NVL(CETSH

Line 1437: JAI_INV_ITM_SETUPS ITEMS

1433: SUM(NVL(JRGI.ADDITIONAL_ED
1434: ,0)) AED_DUTY_PAYABLE
1435: FROM
1436: JAI_CMN_RG_I_TRXS JRGI,
1437: JAI_INV_ITM_SETUPS ITEMS
1438: WHERE JRGI.TRANSACTION_TYPE in ( 'I' , 'PI' , 'IA' , 'IOI' )
1439: AND ( JRGI.INVENTORY_ITEM_ID = cf_duty_payableformula.INVENTORY_ITEM_ID
1440: OR ITEMS.ITEM_TARIFF = CETSH )
1441: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID

Line 1465: JAI_INV_ITM_SETUPS ITEMS

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 )
1469: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID

Line 1528: JAI_INV_ITM_SETUPS ITEMS

1524: SELECT
1525: REGISTER_ID_PART_II
1526: FROM
1527: JAI_CMN_RG_I_TRXS JRGI,
1528: JAI_INV_ITM_SETUPS ITEMS
1529: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_other_dutiesformula.INVENTORY_ITEM_ID
1530: OR ITEMS.ITEM_TARIFF = CETSH )
1531: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID
1532: AND JRGI.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 1559: JAI_INV_ITM_SETUPS ITEMS

1555: SELECT
1556: REGISTER_ID_PART_II
1557: FROM
1558: JAI_CMN_RG_I_TRXS JRGI,
1559: JAI_INV_ITM_SETUPS ITEMS
1560: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_other_dutiesformula.INVENTORY_ITEM_ID
1561: OR ITEMS.ITEM_TARIFF = CETSH )
1562: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID
1563: AND JRGI.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 1590: JAI_INV_ITM_SETUPS ITEMS

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
1594: AND JRGI.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 1617: JAI_INV_ITM_SETUPS ITEMS

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
1621: AND JRGI.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 1757: JAI_INV_ITM_SETUPS JMSI

1753: AND not exists (
1754: SELECT
1755: 1
1756: FROM
1757: JAI_INV_ITM_SETUPS JMSI
1758: WHERE JIRP.ORGANIZATION_ID = JMSI.ORGANIZATION_ID
1759: AND JIRP.INVENTORY_ITEM_ID = JMSI.INVENTORY_ITEM_ID
1760: AND ( JMSI.ITEM_CLASS = 'RMEX'
1761: OR ( JMSI.ITEM_CLASS = 'RMIN'

Line 1798: JAI_INV_ITM_SETUPS JMSI

1794: AND not exists (
1795: SELECT
1796: 1
1797: FROM
1798: JAI_INV_ITM_SETUPS JMSI
1799: WHERE JIRP.ORGANIZATION_ID = JMSI.ORGANIZATION_ID
1800: AND JIRP.INVENTORY_ITEM_ID = JMSI.INVENTORY_ITEM_ID
1801: AND ( JMSI.ITEM_CLASS = 'RMEX'
1802: OR ( JMSI.ITEM_CLASS = 'RMIN'

Line 1836: JAI_INV_ITM_SETUPS JMSI

1832: AND not exists (
1833: SELECT
1834: 1
1835: FROM
1836: JAI_INV_ITM_SETUPS JMSI
1837: WHERE JIRP.ORGANIZATION_ID = JMSI.ORGANIZATION_ID
1838: AND JIRP.INVENTORY_ITEM_ID = JMSI.INVENTORY_ITEM_ID
1839: AND ( JMSI.ITEM_CLASS = 'RMEX'
1840: OR ( JMSI.ITEM_CLASS = 'RMIN'

Line 1866: JAI_INV_ITM_SETUPS JMSI

1862: ,0)
1863: ,0) CREDIT_ON_IMPORT_INPUTS
1864: FROM
1865: JAI_CMN_RG_23AC_II_TRXS JIRP,
1866: JAI_INV_ITM_SETUPS JMSI
1867: WHERE JIRP.LOCATION_ID = P_LOCATION_ID
1868: AND JIRP.ORGANIZATION_ID = P_ORGANIZATION_ID
1869: AND JIRP.ORGANIZATION_ID = JMSI.ORGANIZATION_ID
1870: AND JIRP.INVENTORY_ITEM_ID = JMSI.INVENTORY_ITEM_ID

Line 1944: JAI_INV_ITM_SETUPS JMSI

1940: AND not exists (
1941: SELECT
1942: 1
1943: FROM
1944: JAI_INV_ITM_SETUPS JMSI
1945: WHERE JIRP.ORGANIZATION_ID = JMSI.ORGANIZATION_ID
1946: AND JIRP.INVENTORY_ITEM_ID = JMSI.INVENTORY_ITEM_ID
1947: AND ( JMSI.ITEM_CLASS = 'RMEX'
1948: OR ( JMSI.ITEM_CLASS = 'RMIN'

Line 1982: JAI_INV_ITM_SETUPS JMSI

1978: AND not exists (
1979: SELECT
1980: 1
1981: FROM
1982: JAI_INV_ITM_SETUPS JMSI
1983: WHERE JIRP.ORGANIZATION_ID = JMSI.ORGANIZATION_ID
1984: AND JIRP.INVENTORY_ITEM_ID = JMSI.INVENTORY_ITEM_ID
1985: AND ( JMSI.ITEM_CLASS = 'RMEX'
1986: OR ( JMSI.ITEM_CLASS = 'RMIN'

Line 2184: LV_CETSH JAI_INV_ITM_SETUPS.ITEM_TARIFF%TYPE;

2180: END CF_CESS_EXCISE_INPUT_STG;
2181:
2182: FUNCTION CF_GET_CETSH(INVENTORY_ITEM_ID IN NUMBER
2183: ,CETSH_SUB IN VARCHAR2) RETURN CHAR IS
2184: LV_CETSH JAI_INV_ITM_SETUPS.ITEM_TARIFF%TYPE;
2185: CURSOR CUR_GET_CETSH IS
2186: SELECT
2187: SUBSTR(JIMSI.ITEM_TARIFF
2188: ,1

Line 2191: JAI_INV_ITM_SETUPS JIMSI

2187: SUBSTR(JIMSI.ITEM_TARIFF
2188: ,1
2189: ,15)
2190: FROM
2191: JAI_INV_ITM_SETUPS JIMSI
2192: WHERE JIMSI.INVENTORY_ITEM_ID = cf_get_cetsh.INVENTORY_ITEM_ID
2193: AND JIMSI.ORGANIZATION_ID = P_ORGANIZATION_ID;
2194: BEGIN
2195: IF (P_GROUP_BY = 'I') THEN

Line 2311: JAI_INV_ITM_SETUPS JMSI

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
2315: AND JMSI.ORGANIZATION_ID = JRG23_II.ORGANIZATION_ID

Line 2393: JAI_INV_ITM_SETUPS JMSI

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
2397: AND JMSI.ORGANIZATION_ID = JRG23_II.ORGANIZATION_ID

Line 2447: JAI_INV_ITM_SETUPS JMSI

2443: ,0))
2444: ,0) CREDIT_AVAILED_ON_CAP_GOODS
2445: FROM
2446: JAI_CMN_RG_23AC_II_TRXS JIRP,
2447: JAI_INV_ITM_SETUPS JMSI
2448: WHERE JIRP.LOCATION_ID = P_LOCATION_ID
2449: AND JIRP.ORGANIZATION_ID = P_ORGANIZATION_ID
2450: AND JIRP.ORGANIZATION_ID = JMSI.ORGANIZATION_ID
2451: AND JIRP.INVENTORY_ITEM_ID = JMSI.INVENTORY_ITEM_ID

Line 3124: JAI_INV_ITM_SETUPS JMSI

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
3128: AND JMSI.ORGANIZATION_ID = JRG23_II.ORGANIZATION_ID

Line 3401: JAI_INV_ITM_SETUPS ITEMS

3397: SELECT
3398: REGISTER_ID_PART_II
3399: FROM
3400: JAI_CMN_RG_I_TRXS JRGI,
3401: JAI_INV_ITM_SETUPS ITEMS
3402: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_sh_other_dutiesformula.INVENTORY_ITEM_ID
3403: OR ITEMS.ITEM_TARIFF = CETSH )
3404: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID
3405: AND JRGI.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 3432: JAI_INV_ITM_SETUPS ITEMS

3428: SELECT
3429: REGISTER_ID_PART_II
3430: FROM
3431: JAI_CMN_RG_I_TRXS JRGI,
3432: JAI_INV_ITM_SETUPS ITEMS
3433: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_sh_other_dutiesformula.INVENTORY_ITEM_ID
3434: OR ITEMS.ITEM_TARIFF = CETSH )
3435: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID
3436: AND JRGI.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 3463: JAI_INV_ITM_SETUPS ITEMS

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
3467: AND JRGI.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 3490: JAI_INV_ITM_SETUPS ITEMS

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
3494: AND JRGI.ORGANIZATION_ID = P_ORGANIZATION_ID