APPS.ENG_ENGRCNDR_XMLP_PKG dependencies on MTL_ITEM_REVISIONS

Line 150: MTL_ITEM_REVISIONS REV

146: SELECT
147: REV.REVISION
148: INTO REV
149: FROM
150: MTL_ITEM_REVISIONS REV
151: WHERE REV.INVENTORY_ITEM_ID = ITEM_ID
152: AND REV.ORGANIZATION_ID = ORG_ID
153: AND REV.EFFECTIVITY_DATE = (
154: SELECT

Line 157: MTL_ITEM_REVISIONS

153: AND REV.EFFECTIVITY_DATE = (
154: SELECT
155: MAX(EFFECTIVITY_DATE)
156: FROM
157: MTL_ITEM_REVISIONS
158: WHERE EFFECTIVITY_DATE <= EFF_DATE
159: AND ORGANIZATION_ID = ORG_ID
160: AND INVENTORY_ITEM_ID = ITEM_ID
161: AND IMPLEMENTATION_DATE is not null )

Line 179: MTL_ITEM_REVISIONS REV

175: SELECT
176: REV.REVISION
177: INTO LATE_REV
178: FROM
179: MTL_ITEM_REVISIONS REV
180: WHERE REV.INVENTORY_ITEM_ID = ITEM_ID
181: AND REV.ORGANIZATION_ID = ORG_ID
182: AND REV.EFFECTIVITY_DATE = (
183: SELECT

Line 186: MTL_ITEM_REVISIONS

182: AND REV.EFFECTIVITY_DATE = (
183: SELECT
184: MAX(EFFECTIVITY_DATE)
185: FROM
186: MTL_ITEM_REVISIONS
187: WHERE ORGANIZATION_ID = ORG_ID
188: AND INVENTORY_ITEM_ID = ITEM_ID );
189: RETURN (LATE_REV);
190: RETURN NULL;