APPS.BOM_BILL_OF_MATLS_PKG dependencies on MTL_ITEM_FLEXFIELDS

Line 33: From mtl_item_flexfields mif

29: Cursor GetCommon (P_Common_Assembly_Item_Id number,
30: P_Common_Organization_Id number) is
31: Select mif.item_number part,
32: mif.description description
33: From mtl_item_flexfields mif
34: Where mif.inventory_item_id = P_Common_Assembly_Item_Id
35: And mif.organization_id = P_Common_Organization_Id;
36: Cursor GetCommonOrg (P_Common_Organization_Id number) is
37: SELECT mp.organization_code ORGANIZATION_CODE, hou.name ORGANIZATION_NAME

Line 45: From mtl_item_flexfields mif

41: AND hou.organization_id = P_Common_Organization_Id;
42: Cursor GetBaseModel (P_Base_Item_Id number, P_Org_Id number) is
43: Select mif.item_number part,
44: mif.description description
45: From mtl_item_flexfields mif
46: Where mif.inventory_item_id = P_Base_Item_Id
47: And mif.organization_id = P_Org_Id;
48: CURSOR GetItemSeq IS
49: SELECT nvl(max(item_num), 0) + P_Item_Seq_Increment default_seq