DBA Data[Home] [Help]

APPS.ENG_ECO_UTIL dependencies on MTL_ITEM_REVISIONS_TL

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

1251: AND msi.bom_item_type in (X_Model, X_OptionClass,
1252: X_Planning, X_Standard)));
1253:
1254:
1255: -------not required to insert to MTL_ITEM_REVISIONS_TL as description is not there.
1256:
1257:
1258:
1259:

Line 1603: --no updation of mtl_item_revisions_tl

1599: WHERE msi.inventory_item_id = eri.revised_item_id
1600: AND msi.organization_id = eri.organization_Id
1601: AND msi.bom_item_type in (X_Model, X_OptionClass,
1602: X_Planning, X_Standard)));
1603: --no updation of mtl_item_revisions_tl
1604:
1605:
1606: IF FND_API.to_Boolean( p_debug ) THEN
1607: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );

Line 2175: delete from MTL_ITEM_REVISIONS_TL

2171: AND ERI.STATUS_TYPE = 5);
2172:
2173: -- Delete item revisions created by revised items on ECO
2174:
2175: delete from MTL_ITEM_REVISIONS_TL
2176: where revision_id in(select revision_id
2177: from MTL_ITEM_REVISIONS_B I
2178: WHERE CHANGE_NOTICE = change_order
2179: AND ORGANIZATION_ID = org_id