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_AR_EER1_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 1814: CURSOR Cur_item_desc( p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type)

1810: ln_pla_duty NUMBER ;
1811: ln_rg23_duty NUMBER ;
1812:
1813:
1814: CURSOR Cur_item_desc( p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type)
1815: IS
1816: SELECT MSI.description
1817: FROM mtl_system_items MSI
1818: WHERE MSI.inventory_item_id = p_inventory_item_id

Line 1824: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,

1820:
1821:
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:

Line 1827: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type)

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)+
1831: NVL(FOR_HOME_USE_PAY_ED_QTY,0)+

Line 1837: FROM JAI_CMN_RG_I_TRXS jrgi,

1833: NVL(FOR_EXPORT_N_PAY_ED_QTY,0)+
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'))

Line 1854: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,

1850:
1851:
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:

Line 1857: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type)

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)+
1861: NVL(FOR_HOME_USE_PAY_ED_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 1883: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,

1879:
1880:
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

Line 1886: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type)

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
1890: WHERE jrgi.transaction_type in ( 'I','PI','IA','IOI')

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 1904: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,

1900: AND to_char(jrgi.creation_date, 'YYYY') || to_char(jrgi.creation_date, 'MM') = ln_yyyymm ;
1901:
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: )

Line 1907: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type

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
1911: WHERE source_register_id IN(

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 1930: p_inventory_item_id IN JAI_CMN_RG_I_TRXS.inventory_item_id%type,

1926: AND source_type = 2
1927: AND tax_type IN (jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess ) ;
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: )

Line 1933: p_units IN JAI_CMN_RG_I_TRXS.primary_uom_code%type

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
1937: WHERE source_register_id IN(

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 1971: JAI_CMN_RG_I_TRXS a ,

1967: sum( nvl(a.basic_ed,0 ) + nvl(a.additional_ed,0) ) duty_payable,
1968: sum( nvl(a.other_ed,0)) other_duties,
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

Line 2016: from JAI_CMN_RG_I_TRXS

2012: AND trunc(creation_date) <= trunc(nvl(p_end_date,sysdate))
2013: AND to_char(creation_date, 'YYYY') || to_char(creation_date, 'MM') = ln_yyyymm
2014: AND register_id not in
2015: ( select NVL(register_id_part_ii,0)
2016: from JAI_CMN_RG_I_TRXS
2017: where payment_register IN ( 'RG23A','RG23C' )
2018: )
2019: );
2020:

Line 2036: from JAI_CMN_RG_I_TRXS

2032: AND TRANSACTION_SOURCE_NUM = 91
2033: AND to_char(creation_date, 'YYYY') || to_char(creation_date, 'MM') = ln_yyyymm
2034: AND register_id not in
2035: ( select NVL(register_id_part_ii,0)
2036: from JAI_CMN_RG_I_TRXS
2037: where payment_register = 'PLA'
2038: )
2039: );
2040: