APPS.EAM_MTL_TXN_PROCESS dependencies on INV_MATERIAL_STATUS_GRP

Line 182: and inv_material_status_grp.is_status_applicable(NULL,NULL,p_trx_type_id,NULL,NULL,

178: where
179: secondary_inventory_name = p_subinv_code
180: and organization_id = p_org_id
181: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
182: and inv_material_status_grp.is_status_applicable(NULL,NULL,p_trx_type_id,NULL,NULL,
183: p_org_id,p_item_id,secondary_inventory_name,NULL,NULL,NULL,'Z') = 'Y' ;
184:
185: elsif(p_subinv_ctrl = 1) then
186: select secondary_inventory_name into p_subinv_code

Line 192: and inv_material_status_grp.is_status_applicable(NULL,NULL,p_trx_type_id,NULL,NULL,

188: where
189: secondary_inventory_name = p_subinv_code
190: and organization_id = p_org_id
191: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
192: and inv_material_status_grp.is_status_applicable(NULL,NULL,p_trx_type_id,NULL,NULL,
193: p_org_id,p_item_id,secondary_inventory_name,NULL,NULL,NULL,'Z') = 'Y'
194: and EXISTS (select secondary_inventory from mtl_item_sub_inventories
195: where secondary_inventory = secondary_inventory_name
196: and inventory_item_id = p_item_id