DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on INV_MATERIAL_STATUS_GRP

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

260: where
261: secondary_inventory_name = p_subinv_code
262: and organization_id = p_org_id
263: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
264: and inv_material_status_grp.is_status_applicable(NULL,NULL,p_trx_type_id,NULL,NULL,
265: p_org_id,p_item_id,secondary_inventory_name,NULL,NULL,NULL,'Z') = 'Y' ;
266:
267: elsif(p_subinv_ctrl = 1) then
268: select secondary_inventory_name into p_subinv_code

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

270: where
271: secondary_inventory_name = p_subinv_code
272: and organization_id = p_org_id
273: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
274: and inv_material_status_grp.is_status_applicable(NULL,NULL,p_trx_type_id,NULL,NULL,
275: p_org_id,p_item_id,secondary_inventory_name,NULL,NULL,NULL,'Z') = 'Y'
276: and EXISTS (select secondary_inventory from mtl_item_sub_inventories
277: where secondary_inventory = secondary_inventory_name
278: and inventory_item_id = p_item_id