APPS.BOM_ROUTINGREVISION_PVT dependencies on MTL_RTG_ITEM_REVISIONS

Line 149: from mtl_rtg_item_revisions

145: Select 'x' dummy
146: from dual
147: Where exists(
148: Select null
149: from mtl_rtg_item_revisions
150: where inventory_item_id = P_ItemId
151: and organization_id = P_OrgId
152: and ((effectivity_date > P_EffDate and
153: process_revision < P_Revision)

Line 442: Insert into mtl_rtg_item_revisions(

438: Else
439: l_ProgramUpdate := sysdate;
440: End if;
441:
442: Insert into mtl_rtg_item_revisions(
443: inventory_item_id,
444: organization_id,
445: process_revision,
446: last_update_date,

Line 585: From mtl_rtg_item_revisions

581: l_ApplicationId NUMBER;
582: cursor l_ExistiongRevision_csr(P_ItemId number, P_OrgId number,
583: P_Revision varchar2) is
584: Select *
585: From mtl_rtg_item_revisions
586: Where inventory_item_id = P_ItemId
587: And organization_id = P_OrgId
588: And process_revision = P_Revision;
589: l_RowsFound boolean := false;

Line 760: update mtl_rtg_item_revisions set

756: Else
757: l_ProgramUpdate := sysdate;
758: End if;
759:
760: update mtl_rtg_item_revisions set
761: last_update_date = sysdate,
762: last_updated_by = l_UserId,
763: creation_date = sysdate,
764: created_by = l_UserId,

Line 855: From mtl_rtg_item_revisions mrir

851: l_msg_data VARCHAR2(2000);
852: cursor l_date_csr(P_ItemId number, P_OrgId number,
853: P_Rev varchar2) is
854: Select 1 dummy
855: From mtl_rtg_item_revisions mrir
856: Where mrir.inventory_item_id = P_ItemId
857: And mrir.organization_id = P_OrgId
858: And mrir.process_revision = P_Rev
859: And mrir.effectivity_date < sysdate;

Line 906: delete from mtl_rtg_item_revisions

902: FND_MSG_PUB.Add;
903: Raise FND_API.G_EXC_ERROR;
904: End loop;
905:
906: delete from mtl_rtg_item_revisions
907: where inventory_item_id = l_RtgRevision_rec.inventory_item_id
908: and organization_id = l_RtgRevision_rec.organization_id
909: and process_revision = l_RtgRevision_rec.process_revision;
910: If sql%NotFound then