DBA Data[Home] [Help]

APPS.ENG_ECO_UTIL dependencies on MTL_ITEM_REVISIONS_TL

Line 1642: -------not required to insert to MTL_ITEM_REVISIONS_TL as description is not there.

1638: AND msi.bom_item_type in (X_Model, X_OptionClass,
1639: X_Planning, X_Standard)));
1640:
1641:
1642: -------not required to insert to MTL_ITEM_REVISIONS_TL as description is not there.
1643:
1644:
1645:
1646:

Line 2030: --no updation of mtl_item_revisions_tl

2026: WHERE msi.inventory_item_id = eri.revised_item_id
2027: AND msi.organization_id = eri.organization_Id
2028: AND msi.bom_item_type in (X_Model, X_OptionClass,
2029: X_Planning, X_Standard)));
2030: --no updation of mtl_item_revisions_tl
2031:
2032:
2033: IF FND_API.to_Boolean( p_debug ) THEN
2034: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );

Line 2602: delete from MTL_ITEM_REVISIONS_TL

2598: AND ERI.STATUS_TYPE = 5);
2599:
2600: -- Delete item revisions created by revised items on ECO
2601:
2602: delete from MTL_ITEM_REVISIONS_TL
2603: where revision_id in(select revision_id
2604: from MTL_ITEM_REVISIONS_B I
2605: WHERE CHANGE_NOTICE = change_order
2606: AND ORGANIZATION_ID = org_id