DBA Data[Home] [Help]

APPS.CSTPSCEX dependencies on MTL_ITEM_REVISIONS

Line 1171: mtl_item_revisions MIR

1167: select
1168: substr( max( to_char( MIR.effectivity_date, 'YYYY/MM/DD HH24:MI:SS' ) ||
1169: MIR.revision ), 20 )
1170: from
1171: mtl_item_revisions MIR
1172: where
1173: MIR.inventory_item_id = CSBS.component_item_id and
1174: MIR.organization_id = CSBS.component_organization_id and
1175: MIR.effectivity_date <= i_effective_date