DBA Data[Home] [Help]

APPS.WIP_COMMON dependencies on MTL_RTG_ITEM_REVISIONS

Line 348: from mtl_rtg_item_revisions

344: -- Modified for ECO implement.
345:
346: IF p_eff_date IS NULL THEN
347: select count(*) into x_rtg_exists
348: from mtl_rtg_item_revisions
349: where inventory_item_id = p_item_id
350: and organization_id = p_Org_id
351: and implementation_date is not null;
352: ELSE

Line 354: from mtl_rtg_item_revisions

350: and organization_id = p_Org_id
351: and implementation_date is not null;
352: ELSE
353: select count(*) into x_rtg_exists
354: from mtl_rtg_item_revisions
355: where inventory_item_id = p_item_id
356: and organization_id = p_Org_id
357: AND effectivity_date <= p_eff_date
358: and implementation_date is not null;