APPS.B_RTG_REVS_PKG dependencies on MTL_RTG_ITEM_REVISIONS

Line 15: FROM mtl_rtg_item_revisions

11: INTO dummy
12: FROM dual
13: WHERE X_Effectivity_Date >
14: (SELECT nvl(max(effectivity_date), X_Effectivity_Date-1)
15: FROM mtl_rtg_item_revisions
16: WHERE inventory_item_id = X_Inventory_Item_Id
17: AND organization_id = X_Organization_Id
18: AND process_revision < X_Process_Revision)
19: AND X_Effectivity_Date <

Line 21: FROM mtl_rtg_item_revisions

17: AND organization_id = X_Organization_Id
18: AND process_revision < X_Process_Revision)
19: AND X_Effectivity_Date <
20: (SELECT nvl(min(effectivity_date), X_Effectivity_Date+1)
21: FROM mtl_rtg_item_revisions
22: WHERE inventory_item_id = X_Inventory_Item_Id
23: and organization_id = X_Organization_Id
24: and process_revision > X_Process_Revision);
25: EXCEPTION

Line 39: WHERE not exists (SELECT 1 from mtl_rtg_item_revisions

35: BEGIN
36: SELECT 1
37: INTO dummy
38: FROM dual
39: WHERE not exists (SELECT 1 from mtl_rtg_item_revisions
40: WHERE organization_id = X_Organization_Id
41: AND inventory_item_id = X_Inventory_Item_Id
42: AND process_revision = X_Process_Revision
43: );