DBA Data[Home] [Help]

APPS.BOMPEXPL dependencies on MTL_ITEM_REVISIONS_B

Line 582: FROM mtl_item_revisions_b MIR

578: p_organization_id IN NUMBER,
579: p_revision_date IN DATE,
580: p_impl_flag IN NUMBER) IS
581: SELECT revision,revision_label,revision_id
582: FROM mtl_item_revisions_b MIR
583: WHERE mir.inventory_item_id = p_inventory_item_id
584: AND mir.organization_id = p_organization_id
585: AND mir.effectivity_date <= p_revision_date
586: AND (p_impl_flag = 2 OR (p_impl_flag = 1 AND mir.implementation_date IS NOT NULL) )