APPS.BOM_VALIDATE_RTG_REVISION dependencies on MTL_RTG_ITEM_REVISIONS

Line 176: FROM mtl_rtg_item_revisions

172: l_Token_Tbl Error_Handler.Token_Tbl_Type;
173: l_eco VARCHAR2(10):= NULL;
174: CURSOR c_created_by_eco IS
175: SELECT change_notice
176: FROM mtl_rtg_item_revisions
177: WHERE inventory_item_id = p_rtg_rev_unexp_rec.assembly_item_id
178: AND organization_id = p_rtg_rev_unexp_rec.organization_id
179: AND process_revision = p_rtg_revision_rec.revision;
180:

Line 263: FROM mtl_rtg_item_revisions

259: )
260: IS
261: CURSOR c_Get_Revision IS
262: SELECT process_revision
263: FROM mtl_rtg_item_revisions
264: WHERE inventory_item_id = p_rtg_rev_unexp_rec.assembly_item_id
265: AND organization_id = p_rtg_rev_unexp_rec.organization_id
266: AND effectivity_date <= sysdate --added by arudresh, bug: 3756380
267: AND IMPLEMENTATION_DATE IS NOT NULL

Line 369: FROM mtl_rtg_item_revisions

365: INTO l_dummy
366: FROM dual
367: WHERE not exists
368: (SELECT 1
369: FROM mtl_rtg_item_revisions
370: WHERE organization_id = p_rtg_rev_Unexp_Rec.Organization_Id
371: AND inventory_item_id = p_rtg_rev_Unexp_Rec.assembly_Item_Id
372: AND process_revision = p_rtg_revision_Rec.revision
373: );

Line 431: FROM mtl_rtg_item_revisions

427: FROM dual
428: WHERE p_rtg_revision_rec.start_effective_date >
429: (SELECT nvl(max(effectivity_date),
430: p_rtg_revision_rec.start_effective_Date-1)
431: FROM mtl_rtg_item_revisions
432: WHERE inventory_item_id = p_rtg_rev_Unexp_Rec.assembly_Item_Id
433: AND organization_id = p_rtg_rev_Unexp_Rec.Organization_Id
434: AND process_revision < p_rtg_revision_rec.Revision
435: )

Line 439: FROM mtl_rtg_item_revisions

435: )
436: AND p_rtg_revision_rec.start_effective_date <
437: (SELECT nvl(min(effectivity_date),
438: p_rtg_revision_rec.start_effective_Date+1)
439: FROM mtl_rtg_item_revisions
440: WHERE inventory_item_id =p_rtg_rev_Unexp_Rec.assembly_Item_Id
441: AND organization_id = p_rtg_rev_Unexp_Rec.Organization_Id
442: AND process_revision > p_rtg_revision_rec.Revision
443: );

Line 464: FROM mtl_rtg_item_revisions

460:
461: IF p_rtg_revision_rec.transaction_type = BOM_Rtg_Globals.G_OPR_DELETE
462: THEN
463: SELECT effectivity_date into l_effectivity_date
464: FROM mtl_rtg_item_revisions
465: WHERE inventory_item_id =p_rtg_rev_Unexp_Rec.assembly_Item_Id
466: AND organization_id = p_rtg_rev_Unexp_Rec.Organization_Id
467: AND process_revision = p_rtg_revision_rec.Revision;
468: IF trunc( l_effectivity_date) <= trunc(SYSDATE)