APPS.BOM_RTG_REVISION_UTIL dependencies on MTL_RTG_ITEM_REVISIONS

Line 99: FROM mtl_rtg_item_revisions

95: , l_rtg_revision_rec.attribute12
96: , l_rtg_revision_rec.attribute13
97: , l_rtg_revision_rec.attribute14
98: , l_rtg_revision_rec.attribute15
99: FROM mtl_rtg_item_revisions
100: WHERE inventory_item_id = p_assembly_item_id
101: AND organization_id = p_organization_id
102: AND process_revision = p_revision;
103:

Line 168: INSERT INTO mtl_rtg_item_revisions

164: || p_rtg_revision_rec.assembly_item_name);
165: END IF;
166:
167: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
168: INSERT INTO mtl_rtg_item_revisions
169: ( inventory_item_id
170: , organization_id
171: , process_revision
172: , implementation_date

Line 277: UPDATE mtl_rtg_item_revisions

273: Error_Handler.Write_Debug('Updating routing revision '
274: || p_rtg_revision_rec.revision);
275: END IF;
276:
277: UPDATE mtl_rtg_item_revisions
278: SET effectivity_date =
279: p_rtg_revision_rec.start_effective_date
280: , implementation_date =
281: p_rtg_revision_rec.start_effective_date

Line 340: DELETE FROM mtl_rtg_item_revisions

336: Error_Handler.Write_Debug('Delete routing revision '
337: || p_rtg_revision_rec.revision);
338: END IF;
339:
340: DELETE FROM mtl_rtg_item_revisions
341: WHERE inventory_item_id = p_rtg_rev_unexp_rec.assembly_item_id
342: AND organization_id = p_rtg_rev_unexp_rec.organization_id
343: AND process_revision = p_rtg_revision_rec.revision;
344: