APPS.JAI_AR_EER1_PKG dependencies on MTL_SYSTEM_ITEMS

Line 1817: FROM mtl_system_items MSI

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
1819: AND MSI.organization_id = p_organization_id;
1820:
1821:

Line 1972: mtl_system_items b ,

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
1976: AND c.organization_id = b.organization_id

Line 2290: mtl_system_items b ,

2286: sum( NVL(a.other_ed,0)) Other_duties,
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

Line 3664: mtl_system_items msi

3660: msi.attribute4 item_tariff,
3661: msi.primary_uom_code
3662: from
3663: JAI_CMN_RG_23AC_I_TRXS jrp,
3664: mtl_system_items msi
3665: where
3666: jrp.organization_id = msi.organization_id
3667: and jrp.inventory_item_id = msi.inventory_item_id
3668: and jrp.location_id = p_location_id