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 169: from JAI_INV_ITM_SETUPS

165: AND location_id = p_location_id;
166:
167: cursor c_get_item_info IS
168: select item_Trading_flag , excise_flag
169: from JAI_INV_ITM_SETUPS
170: where inventory_item_id = p_item_id
171: and organization_id = p_organization_id;
172:
173: BEGIN

Line 344: JAI_INV_ITM_SETUPS itm

340: trx.last_update_date,
341: trx.last_update_login
342: FROM jai_mtl_trxs trx,
343: JAI_INV_SUBINV_DTLS subinv,
344: JAI_INV_ITM_SETUPS itm
345: WHERE subinv.organization_id = trx.to_organization
346: AND itm.organization_id = trx.to_organization
347: AND itm.inventory_item_id = trx.inventory_item_id
348: AND subinv.sub_inventory_name = trx.to_subinventory

Line 1475: from JAI_INV_ITM_SETUPS

1471: WHERE organization_id = p_org_id;
1472:
1473: CURSOR c_item_class (cp_inv_item_id IN NUMBER , cp_orgn_id IN NUMBER) IS
1474: select item_class
1475: from JAI_INV_ITM_SETUPS
1476: where inventory_item_id = cp_inv_item_id
1477: and organization_id = cp_orgn_id ;
1478:
1479: r_item_class c_item_class%rowtype;

Line 2767: JAI_INV_ITM_SETUPS jiis

2763: cursor cur_item_class /*6501436*/
2764: IS
2765: SELECT jiis.item_class
2766: FROM jai_mtl_trxs jmt,
2767: JAI_INV_ITM_SETUPS jiis
2768: WHERE jmt.inventory_item_id = jiis.inventory_item_id
2769: AND jmt.transaction_temp_id = p_trx_temp_id;
2770:
2771: lv_item_class jai_inv_itm_setups.item_class%TYPE;/*6501436*/

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