APPS.JAI_OM_TAX_PROCESSING_PKG dependencies on MTL_SYSTEM_ITEMS

Line 50: v_container_item_flag mtl_system_items.container_item_flag%type;

46: v_trad_register_code VARCHAR2(30);
47: v_location_id NUMBER;
48: v_exe_flag VARCHAR2(150);
49: v_mod_flag VARCHAR2(150);
50: v_container_item_flag mtl_system_items.container_item_flag%type;
51: lv_inventory_item_flag mtl_system_items.inventory_item_flag%type;
52: ln_ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%type;
53:
54: /* variables used in debug package */

Line 51: lv_inventory_item_flag mtl_system_items.inventory_item_flag%type;

47: v_location_id NUMBER;
48: v_exe_flag VARCHAR2(150);
49: v_mod_flag VARCHAR2(150);
50: v_container_item_flag mtl_system_items.container_item_flag%type;
51: lv_inventory_item_flag mtl_system_items.inventory_item_flag%type;
52: ln_ship_from_location_id WSH_DELIVERY_DETAILS.ship_from_location_id%type;
53:
54: /* variables used in debug package */
55: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE ;

Line 102: mtl_system_items msi,

98: modvat_flag ,
99: nvl(container_item_flag,'N'),
100: nvl(inventory_item_flag,'N')
101: FROM
102: mtl_system_items msi,
103: JAI_INV_ITM_SETUPS jmsi
104: WHERE msi.organization_id = jmsi.organization_id
105: AND msi.inventory_item_id = jmsi.inventory_item_id
106: AND jmsi.inventory_item_id = v_Inventory_Item_Id