DBA Data[Home] [Help]

APPS.BOM_ROUTINGHEADER_PVT dependencies on MTL_RTG_ITEM_REVISIONS

Line 1270: insert into mtl_rtg_item_revisions(

1266: l_routing_rec.total_product_cycle_time,
1267: l_routing_rec.pending_from_ecn);
1268:
1269: If l_routing_rec.alternate_routing_designator is null then
1270: insert into mtl_rtg_item_revisions(
1271: inventory_item_id,
1272: organization_id,
1273: process_revision,
1274: last_update_date,

Line 1296: from mtl_rtg_item_revisions

1292: from mtl_parameters mp
1293: where mp.organization_id = l_routing_rec.organization_id
1294: and not exists (
1295: select null
1296: from mtl_rtg_item_revisions
1297: where organization_id = l_routing_rec.organization_id
1298: and inventory_item_id = l_routing_rec.assembly_item_id);
1299: End if; -- starting routing revision
1300: