DBA Data[Home] [Help]

APPS.PRODUCT_FAMILY_PKG dependencies on MTL_SYSTEM_ITEMS

Line 13: UPDATE MTL_SYSTEM_ITEMS

9: X_Error_Msg IN OUT NOCOPY VARCHAR2,
10: X_Error_Code IN OUT NOCOPY NUMBER) IS
11: BEGIN
12:
13: UPDATE MTL_SYSTEM_ITEMS
14: SET Product_Family_Item_Id = X_PF_Item_Id
15: WHERE Inventory_Item_Id = X_Inventory_Item_Id
16: and Organization_id = X_Organization_Id;
17:

Line 158: FROM MTL_System_Items MSI,

154: CURSOR X_MemberDetail IS
155: SELECT ML1.Meaning Bom_Item_Type,
156: ML2.Meaning Forecast_Control,
157: ML3.Meaning Planning_Method
158: FROM MTL_System_Items MSI,
159: MFG_Lookups ML1,
160: MFG_Lookups ML2,
161: MFG_Lookups ML3
162: WHERE MSI.Inventory_Item_Id = p_Component_Item_Id