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_MTL_TRXS_PKG dependencies on JAI_INV_ITM_SETUPS

Line 292: from JAI_INV_ITM_SETUPS

288: AND location_id = p_location_id;
289:
290: cursor c_get_item_info IS
291: select item_Trading_flag , excise_flag
292: from JAI_INV_ITM_SETUPS
293: where inventory_item_id = p_item_id
294: and organization_id = p_organization_id;
295:
296: BEGIN

Line 467: JAI_INV_ITM_SETUPS itm

463: trx.last_update_date,
464: trx.last_update_login
465: FROM jai_mtl_trxs trx,
466: JAI_INV_SUBINV_DTLS subinv,
467: JAI_INV_ITM_SETUPS itm
468: WHERE subinv.organization_id = trx.to_organization
469: AND itm.organization_id = trx.to_organization
470: AND itm.inventory_item_id = trx.inventory_item_id
471: AND subinv.sub_inventory_name = trx.to_subinventory

Line 1603: from JAI_INV_ITM_SETUPS

1599: WHERE organization_id = p_org_id;
1600:
1601: CURSOR c_item_class (cp_inv_item_id IN NUMBER , cp_orgn_id IN NUMBER) IS
1602: select item_class
1603: from JAI_INV_ITM_SETUPS
1604: where inventory_item_id = cp_inv_item_id
1605: and organization_id = cp_orgn_id ;
1606:
1607: r_item_class c_item_class%rowtype;

Line 2931: JAI_INV_ITM_SETUPS jiis

2927: cursor cur_item_class /*6501436*/
2928: IS
2929: SELECT jiis.item_class
2930: FROM jai_mtl_trxs jmt,
2931: JAI_INV_ITM_SETUPS jiis
2932: WHERE jmt.inventory_item_id = jiis.inventory_item_id
2933: AND jmt.transaction_temp_id = p_trx_temp_id;
2934:
2935: lv_item_class jai_inv_itm_setups.item_class%TYPE;/*6501436*/

Line 2935: lv_item_class jai_inv_itm_setups.item_class%TYPE;/6501436/