DBA Data[Home] [Help]

APPS.CS_SR_FUL_PKG dependencies on MTL_ITEM_REVISIONS

Line 304: from cs_sr_inv_components_v sr_comp, mtl_item_revisions rev

300:
301: -- Modification of below cursor to include version for Bug 3592225.Prayadur.
302: CURSOR cs_inv_comp_csr is
303: select concatenated_segments, sr_comp.description,revision
304: from cs_sr_inv_components_v sr_comp, mtl_item_revisions rev
305: where
306: sr_comp.component_id = rev.inventory_item_id and
307: sr_comp.organization_id = rev.organization_id and
308: sr_comp.inventory_item_id = l_inventory_item_id and

Line 315: from cs_sr_inv_subcomponents_v sr_sub, mtl_item_revisions rev

311:
312: -- Modification of below cursor to include version for Bug 3592225.Prayadur.
313: CURSOR cs_inv_subcomp_csr is
314: select concatenated_segments, sr_sub.description,revision
315: from cs_sr_inv_subcomponents_v sr_sub, mtl_item_revisions rev
316: where
317: sr_sub.component_id = rev.inventory_item_id and
318: sr_sub.organization_id = rev.organization_id and
319: sr_sub.component_id = l_inv_component_id and