DBA Data[Home] [Help]

APPS.ENG_DEFAULT_REVISED_ITEM dependencies on MTL_ITEM_REVISIONS

Line 270: FROM PA_EGO_LIFECYCLES_PHASES_V LP, MTL_ITEM_REVISIONS MIR

266: BEGIN
267:
268: /*SELECT LP.PROJ_ELEMENT_ID
269: into l_id
270: FROM PA_EGO_LIFECYCLES_PHASES_V LP, MTL_ITEM_REVISIONS MIR
271: WHERE
272: LP.PROJ_ELEMENT_ID =MIR.CURRENT_PHASE_ID
273: AND MIR.INVENTORY_ITEM_ID = p_rev_item_id
274: AND MIR.ORGANIZATION_ID = p_org_id

Line 340: * at the mtl_item_revisions table and return the revision that

336: * Paramters IN : Revised itemid
337: * Organization ID
338: * Revision Date
339: * Purpose : Function will return the current item revision bu looking
340: * at the mtl_item_revisions table and return the revision that
341: * has implementation date NOT NULL and is currently effective.
342: ******************************************************************************/
343: FUNCTION Get_Current_Item_Revision
344: ( p_revised_item_id IN NUMBER

Line 353: FROM MTL_ITEM_REVISIONS

349: l_current_revision VARCHAR2(3) := NULL;
350:
351: CURSOR NO_ECO_ITEM_REV IS
352: SELECT REVISION
353: FROM MTL_ITEM_REVISIONS
354: WHERE INVENTORY_ITEM_ID = p_revised_item_id
355: AND ORGANIZATION_ID = p_organization_id
356: AND EFFECTIVITY_DATE <= p_revision_date
357: AND IMPLEMENTATION_DATE IS NOT NULL

Line 1383: FROM MTL_ITEM_REVISIONS

1379:
1380: l_rev_already_exists NUMBER := 0;
1381: CURSOR c_CheckRevision ( p_revision VARCHAR2) IS
1382: SELECT 1
1383: FROM MTL_ITEM_REVISIONS
1384: WHERE inventory_item_id = p_rev_item_unexp_rec.revised_item_id
1385: AND organization_id = p_rev_item_unexp_rec.organization_id
1386: AND revision = p_revision;
1387:

Line 1591: -- Can insert a revision into MTL_ITEM_REVISIONS only

1587: l_rev_item_unexp_rec.organization_id
1588: , p_revision_date => SYSDATE
1589: );
1590:
1591: -- Can insert a revision into MTL_ITEM_REVISIONS only
1592: -- if it is not the same as the Current Revision
1593:
1594: IF l_revised_item_rec.new_revised_item_revision <>
1595: l_current_revision AND

Line 1641: -- MTL_ITEM_REVISIONS

1637: FND_API.G_MISS_CHAR
1638: THEN
1639: --
1640: -- Insert new revision information into
1641: -- MTL_ITEM_REVISIONS
1642: --
1643: IF l_revised_item_rec.new_revised_item_revision IS NULL OR
1644: l_revised_item_rec.new_revised_item_revision
1645: = l_current_revision -- Added by MK on 02/13/2001

Line 1654: -- MTL_ITEM_REVISIONS

1650: ELSE
1651: --
1652: -- Modified by MK on 10/24/00
1653: -- Update new revision information into
1654: -- MTL_ITEM_REVISIONS
1655: --
1656: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Item Revision set for Update. . .'); END IF;
1657: G_DEL_UPD_INS_ITEM_REV := 2 ;
1658: END IF ;

Line 1689: -- MTL_ITEM_REVISIONS

1685: <> l_current_revision
1686: THEN
1687:
1688: -- Update new item revision information in
1689: -- MTL_ITEM_REVISIONS
1690: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Item Revision set for Update. . .'); END IF;
1691: G_DEL_UPD_INS_ITEM_REV := 2;
1692:
1693: END IF; /* If Update Ends */