DBA Data[Home] [Help]

APPS.BOM_RTG_HEADER_UTIL dependencies on MTL_RTG_ITEM_REVISIONS

Line 257: INSERT INTO MTL_RTG_ITEM_REVISIONS

253: IF p_rtg_header_rec.alternate_routing_code IS NULL
254: AND nvl(Bom_Globals.get_caller_type(),'') <> 'MIGRATION' -- Bug 2871039
255: THEN
256: -- Create a new routing revision for the created primary routing
257: INSERT INTO MTL_RTG_ITEM_REVISIONS
258: ( inventory_item_id
259: , organization_id
260: , process_revision
261: , implementation_date

Line 291: FROM MTL_RTG_ITEM_REVISIONS

287: , SYSDATE
288: FROM MTL_PARAMETERS mp
289: WHERE mp.organization_id = p_rtg_header_unexp_rec.organization_id
290: AND NOT EXISTS( SELECT NULL
291: FROM MTL_RTG_ITEM_REVISIONS
292: WHERE implementation_date IS NOT NULL
293: AND organization_id = p_rtg_header_unexp_rec.organization_id
294: AND inventory_item_id = p_rtg_header_unexp_rec.assembly_item_id
295: ) ;