APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on MTL_SYSTEM_ITEMS

Line 45: v_container_item_flag mtl_system_items.container_item_flag%type ;

41: v_item_trading_flag VARCHAR2(1) ;
42: v_location_id NUMBER ;
43: v_exe_flag VARCHAR2(150) ;
44: v_mod_flag VARCHAR2(150) ;
45: v_container_item_flag mtl_system_items.container_item_flag%type ;
46: lv_inventory_item_flag mtl_system_items.inventory_item_flag%type ;
47: le_error EXCEPTION ;
48:
49: CURSOR Location_Cursor

Line 46: lv_inventory_item_flag mtl_system_items.inventory_item_flag%type ;

42: v_location_id NUMBER ;
43: v_exe_flag VARCHAR2(150) ;
44: v_mod_flag VARCHAR2(150) ;
45: v_container_item_flag mtl_system_items.container_item_flag%type ;
46: lv_inventory_item_flag mtl_system_items.inventory_item_flag%type ;
47: le_error EXCEPTION ;
48:
49: CURSOR Location_Cursor
50: IS

Line 104: mtl_system_items msi,

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