DBA Data[Home] [Help]

APPS.WIP_COMMON dependencies on MTL_RTG_ITEM_REVISIONS

Line 403: from mtl_rtg_item_revisions

399: -- Modified for ECO implement.
400:
401: IF p_eff_date IS NULL THEN
402: select count(*) into x_rtg_exists
403: from mtl_rtg_item_revisions
404: where inventory_item_id = p_item_id
405: and organization_id = p_Org_id
406: and implementation_date is not null;
407: ELSE

Line 409: from mtl_rtg_item_revisions

405: and organization_id = p_Org_id
406: and implementation_date is not null;
407: ELSE
408: select count(*) into x_rtg_exists
409: from mtl_rtg_item_revisions
410: where inventory_item_id = p_item_id
411: and organization_id = p_Org_id
412: AND effectivity_date <= p_eff_date
413: and implementation_date is not null;