APPS.CSTPSCEX dependencies on MTL_ITEM_REVISIONS

Line 1162: mtl_item_revisions MIR

1158: select
1159: substr( max( to_char( MIR.effectivity_date, 'YYYY/MM/DD HH24:MI:SS' ) ||
1160: MIR.revision ), 20 )
1161: from
1162: mtl_item_revisions MIR
1163: where
1164: MIR.inventory_item_id = CSBS.component_item_id and
1165: MIR.organization_id = CSBS.component_organization_id and
1166: MIR.effectivity_date <= i_effective_date