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.JAI_AR_EER1_PKG dependencies on JAI_INV_ITM_SETUPS

Line 1826: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,

1822: -- Cursor for quantity manufactured
1823: CURSOR cur_qty_mftrd(
1824: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,
1825: p_excise_duty_rate IN NUMBER,
1826: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,
1827: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type)
1828:
1829: IS
1830: SELECT sum( NVL(MANUFACTURED_LOOSE_QTY,0)+

Line 1838: JAI_INV_ITM_SETUPS items

1834: NVL(TO_OTHER_FACTORY_N_PAY_ED_QTY,0)+
1835: NVL(OTHER_PURPOSE_N_PAY_ED_QTY,0)+
1836: NVL(OTHER_PURPOSE_PAY_ED_QTY,0)) QTY_MANUFACTURED
1837: FROM JAI_CMN_RG_I_TRXS jrgi,
1838: JAI_INV_ITM_SETUPS items
1839: WHERE jrgi.transaction_type in ( 'R','PR','RA','IOR','CR')
1840: AND (jrgi.inventory_item_id = p_inventory_item_id
1841: OR nvl(items.item_tariff,'xyz') = nvl(p_cetsh,'xyz'))
1842: AND items.inventory_item_id = jrgi.inventory_item_id

Line 1856: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,

1852: -- Cursor for quantity cleared
1853: CURSOR cur_qty_clrd(
1854: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,
1855: p_excise_duty_rate IN NUMBER,
1856: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,
1857: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type)
1858:
1859: IS
1860: SELECT sum( NVL(MANUFACTURED_LOOSE_QTY,0)+

Line 1867: FROM JAI_CMN_RG_I_TRXS jrgi,JAI_INV_ITM_SETUPS items

1863: NVL(FOR_EXPORT_N_PAY_ED_QTY,0)+
1864: NVL(TO_OTHER_FACTORY_N_PAY_ED_QTY,0)+
1865: NVL(OTHER_PURPOSE_N_PAY_ED_QTY,0)+
1866: NVL(OTHER_PURPOSE_PAY_ED_QTY,0)) QTY_MANUFACTURED
1867: FROM JAI_CMN_RG_I_TRXS jrgi,JAI_INV_ITM_SETUPS items
1868: WHERE jrgi.transaction_type in ( 'I','IA','PI','IOI')
1869: AND ( jrgi.inventory_item_id = p_inventory_item_id
1870: OR nvl(items.item_tariff,'xyz') = nvl(p_cetsh,'xyz'))
1871: AND items.inventory_item_id = jrgi.inventory_item_id

Line 1885: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,

1881: -- Cursor for cenvat duty payable
1882: CURSOR cur_duty_payable(
1883: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,
1884: p_excise_duty_rate IN NUMBER,
1885: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,
1886: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type)
1887: IS
1888: SELECT round(sum( NVL(jrgi.basic_ed,0 ) + NVL(jrgi.additional_ed,0) + NVL(jrgi.other_ed,0) ),0) Duty_payable
1889: FROM JAI_CMN_RG_I_TRXS jrgi,JAI_INV_ITM_SETUPS items

Line 1889: FROM JAI_CMN_RG_I_TRXS jrgi,JAI_INV_ITM_SETUPS items

1885: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,
1886: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type)
1887: IS
1888: SELECT round(sum( NVL(jrgi.basic_ed,0 ) + NVL(jrgi.additional_ed,0) + NVL(jrgi.other_ed,0) ),0) Duty_payable
1889: FROM JAI_CMN_RG_I_TRXS jrgi,JAI_INV_ITM_SETUPS items
1890: WHERE jrgi.transaction_type in ( 'I','PI','IA','IOI')
1891: AND ( jrgi.inventory_item_id = p_inventory_item_id
1892: OR items.item_tariff = p_cetsh)
1893: AND items.inventory_item_id = jrgi.inventory_item_id

Line 1906: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,

1902: -- Cursor for Duty Payable(CESS) and Duty Payable(EDU.CESS)
1903: CURSOR cur_other_duties_PLA(
1904: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,
1905: p_excise_duty_rate IN NUMBER,
1906: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,
1907: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type
1908: )
1909: IS
1910: SELECT nvl(sum(debit),0) FROM JAI_CMN_RG_OTHERS

Line 1913: FROM JAI_CMN_RG_I_TRXS jrgi,JAI_INV_ITM_SETUPS items

1909: IS
1910: SELECT nvl(sum(debit),0) FROM JAI_CMN_RG_OTHERS
1911: WHERE source_register_id IN(
1912: SELECT register_id_part_ii
1913: FROM JAI_CMN_RG_I_TRXS jrgi,JAI_INV_ITM_SETUPS items
1914: WHERE ( jrgi.inventory_item_id = p_inventory_item_id
1915: OR items.item_tariff = p_cetsh)
1916: AND items.inventory_item_id = jrgi.inventory_item_id
1917: AND jrgi.organization_id = p_organization_id

Line 1932: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,

1928:
1929: CURSOR cur_other_duties_RG23(
1930: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,
1931: p_excise_duty_rate IN NUMBER,
1932: p_cetsh IN JAI_INV_ITM_SETUPS.item_tariff%type,
1933: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type
1934: )
1935: IS
1936: SELECT nvl(sum(debit),0)FROM JAI_CMN_RG_OTHERS

Line 1938: SELECT register_id_part_ii FROM JAI_CMN_RG_I_TRXS jrgi, JAI_INV_ITM_SETUPS items

1934: )
1935: IS
1936: SELECT nvl(sum(debit),0)FROM JAI_CMN_RG_OTHERS
1937: WHERE source_register_id IN(
1938: SELECT register_id_part_ii FROM JAI_CMN_RG_I_TRXS jrgi, JAI_INV_ITM_SETUPS items
1939: WHERE ( jrgi.inventory_item_id = p_inventory_item_id
1940: OR items.item_tariff = p_cetsh )
1941: AND items.inventory_item_id = jrgi.inventory_item_id
1942: AND jrgi.organization_id = p_organization_id

Line 1973: JAI_INV_ITM_SETUPS c

1969: a.organization_id -- added, Harshita for Bug 5637136
1970: FROM
1971: JAI_CMN_RG_I_TRXS a ,
1972: mtl_system_items b ,
1973: JAI_INV_ITM_SETUPS c
1974: WHERE a.inventory_item_id = b.inventory_item_id
1975: AND c.inventory_item_id = b.inventory_item_id
1976: AND c.organization_id = b.organization_id
1977: AND a.organization_id = b.organization_id

Line 2057: JAI_INV_ITM_SETUPS items

2053: is
2054: SELECT sum( NVL(jrgi.basic_ed,0 ) + NVL(jrgi.other_ed,0) ) Duty_payable,
2055: sum( NVL(jrgi.additional_ed,0)) aed_duty_payable
2056: FROM JAI_CMN_RG_23AC_I_TRXS jrgi,
2057: JAI_INV_ITM_SETUPS items
2058: WHERE jrgi.transaction_type in ( 'RTV', 'I', 'IA', 'IOI', 'PI')
2059: and ( jrgi.inventory_item_id = cp_inventory_item_id
2060: OR items.item_tariff = cp_cetsh
2061: )

Line 2079: JAI_INV_ITM_SETUPS items

2075: FROM JAI_CMN_RG_OTHERS
2076: WHERE source_register_id IN
2077: ( SELECT register_id_part_ii
2078: FROM JAI_CMN_RG_23AC_I_TRXS jrgi,
2079: JAI_INV_ITM_SETUPS items
2080: WHERE ( items.item_tariff = cp_cetsh
2081: )
2082: and items.inventory_item_id = jrgi.inventory_item_id
2083: and jrgi.organization_id = p_organization_id

Line 2103: JAI_INV_ITM_SETUPS items

2099: FROM JAI_CMN_RG_OTHERS
2100: WHERE source_register_id IN
2101: ( SELECT register_id_part_ii
2102: FROM JAI_CMN_RG_23AC_I_TRXS jrgi,
2103: JAI_INV_ITM_SETUPS items
2104: WHERE items.item_tariff = cp_cetsh
2105: and items.inventory_item_id = jrgi.inventory_item_id
2106: and jrgi.organization_id = p_organization_id
2107: and items.organization_id = jrgi.organization_id

Line 2291: JAI_INV_ITM_SETUPS c

2287: a.organization_id
2288: FROM
2289: JAI_CMN_RG_23AC_I_TRXS A ,
2290: mtl_system_items b ,
2291: JAI_INV_ITM_SETUPS c
2292: where a.inventory_item_id = b.inventory_item_id
2293: and c.inventory_item_id = b.inventory_item_id
2294: and c.organization_id = b.organization_id
2295: and a.organization_id = b.organization_id

Line 2657: FROM JAI_CMN_RG_23AC_II_TRXS jrg23_ii ,JAI_CMN_RG_23AC_I_TRXS jrg23_i,JAI_INV_ITM_SETUPS jmsi

2653:
2654: CURSOR get_cgin_sales
2655: IS
2656: SELECT sum(nvl(jrg23_ii.DR_BASIC_ED,0) + nvl(jrg23_ii.DR_ADDITIONAL_ED,0) + nvl(jrg23_ii.DR_OTHER_ED,0))
2657: FROM JAI_CMN_RG_23AC_II_TRXS jrg23_ii ,JAI_CMN_RG_23AC_I_TRXS jrg23_i,JAI_INV_ITM_SETUPS jmsi
2658: WHERE jrg23_ii.organization_id = jrg23_i.organization_id
2659: AND jrg23_ii.location_id = jrg23_i.location_id
2660: AND jrg23_ii.register_id_part_i = jrg23_i.register_id
2661: AND jmsi.organization_id = jrg23_ii.organization_id

Line 2825: SELECT jrg23_ii.register_id FROM JAI_CMN_RG_23AC_II_TRXS jrg23_ii ,JAI_CMN_RG_23AC_I_TRXS jrg23_i,JAI_INV_ITM_SETUPS jmsi

2821: FROM JAI_CMN_RG_OTHERS
2822: WHERE source_type = 1
2823: AND tax_type in ( jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess)
2824: AND source_register_id in (
2825: SELECT jrg23_ii.register_id FROM JAI_CMN_RG_23AC_II_TRXS jrg23_ii ,JAI_CMN_RG_23AC_I_TRXS jrg23_i,JAI_INV_ITM_SETUPS jmsi
2826: WHERE jrg23_ii.organization_id = jrg23_i.organization_id
2827: AND jrg23_ii.location_id = jrg23_i.location_id
2828: AND jrg23_ii.register_id_part_i = jrg23_i.register_id
2829: AND jmsi.organization_id = jrg23_ii.organization_id