APPS.BOM_ROLLUP_PUB dependencies on MTL_SYSTEM_ITEMS

Line 250: , p_Attribute_Table_Name => 'MTL_SYSTEM_ITEMS_B'

246: , p_Attribute_Value => NULL
247: , p_Attribute_Type => 'VARCHAR2'
248: , p_Compute_Function => NULL
249: , p_Object_Name => 'EGO_ITEM'
250: , p_Attribute_Table_Name => 'MTL_SYSTEM_ITEMS_B'
251: );
252:
253: Add_Attribute_Map_Entry
254: ( p_Attribute_Name => 'GROSS_WEIGHT_UOM'

Line 259: , p_Attribute_Table_Name => 'MTL_SYSTEM_ITEMS_B'

255: , p_Attribute_Value => NULL
256: , p_Attribute_Type => 'VARCHAR2'
257: , p_Compute_Function => NULL
258: , p_Object_Name => 'EGO_ITEM'
259: , p_Attribute_Table_Name => 'MTL_SYSTEM_ITEMS_B'
260: );
261: --UOM ROLLUP
262: Add_Attribute_Map_Entry
263: ( p_Attribute_Name => 'UNIT_WEIGHT'

Line 268: , p_Attribute_Table_Name => 'MTL_SYSTEM_ITEMS_B'

264: , p_Attribute_Value => NULL
265: , p_Attribute_Type => 'NUMBER'
266: , p_Compute_Function => 'Bom_Compute_Functions.Compute_Net_Weight'
267: , p_Object_Name => 'EGO_ITEM'
268: , p_Attribute_Table_Name => 'MTL_SYSTEM_ITEMS_B'
269: );
270:
271:
272: Add_Attribute_Map_Entry

Line 338: , p_Attribute_Table_Name => 'MTL_SYSTEM_ITEMS_B'

334: , p_Attribute_Value => NULL
335: , p_Attribute_Type => 'VARCHAR2'
336: , p_Compute_Function => NULL
337: , p_Object_Name => 'EGO_ITEM'
338: , p_Attribute_Table_Name => 'MTL_SYSTEM_ITEMS_B'
339: );
340:
341: Add_Attribute_Map_Entry
342: ( p_Attribute_Name => 'PARENT_IS_ITEM_CONS_UNIT'

Line 356: , p_Attribute_Table_Name => 'MTL_SYSTEM_ITEMS_B'

352: , p_Attribute_Value => NULL
353: , p_Attribute_Type => 'VARCHAR2'
354: , p_Compute_Function => NULL
355: , p_Object_Name => 'EGO_ITEM'
356: , p_Attribute_Table_Name => 'MTL_SYSTEM_ITEMS_B'
357: );
358:
359: Add_Attribute_Map_Entry
360: ( p_Attribute_Name => 'MANUFACTURER_ID'

Line 660: Mtl_System_Items_b MTL,

656: MTL.INVENTORY_ITEM_ID inventory_item_id,
657: nvl(UNIT_WEIGHT,0) unit_weight,
658: LLC.assembly_item_id parent_item_id
659: FROM
660: Mtl_System_Items_b MTL,
661: bom_explosions_all LLC
662: WHERE
663: LLC.group_id = p_rollup_id
664: AND LLC.plan_level = p_level

Line 704: FROM mtl_system_items MTL2,

700: ,gtn_attrs.uom_storage_handling_temp_max
701: ,mtl2.trade_item_descriptor tiud
702: ,gtn_attrs.inventory_item_id inv_id
703: ,gtn_attrs_parent.inventory_item_id inv_id1
704: FROM mtl_system_items MTL2,
705: bom_inventory_components COM,
706: mtl_system_items MTL1,
707: bom_bill_of_materials BOM,
708: ego_item_gtn_attrs_b gtn_attrs,

Line 706: mtl_system_items MTL1,

702: ,gtn_attrs.inventory_item_id inv_id
703: ,gtn_attrs_parent.inventory_item_id inv_id1
704: FROM mtl_system_items MTL2,
705: bom_inventory_components COM,
706: mtl_system_items MTL1,
707: bom_bill_of_materials BOM,
708: ego_item_gtn_attrs_b gtn_attrs,
709: ego_item_gtn_attrs_tl gtn_attrs_tl,
710: ego_item_gtn_attrs_b gtn_attrs_parent

Line 778: FROM mtl_system_items_b

774: AND organization_id = p_organization_id;
775:
776: CURSOR get_gdsn_enabled IS
777: SELECT GDSN_OUTBOUND_ENABLED_FLAG
778: FROM mtl_system_items_b
779: WHERE inventory_item_id = p_item_id
780: AND organization_id = p_organization_id;
781:
782: x_row_id VARCHAR2(1000);

Line 860: FROM mtl_system_items_b

856: l_login_id := FND_GLOBAL.LOGIN_ID;
857:
858: SELECT item_catalog_group_id
859: INTO l_catalog_id
860: FROM mtl_system_items_b
861: WHERE inventory_item_id = p_item_id
862: AND organization_id = p_organization_id;
863:
864: IF l_catalog_id IS NULL THEN

Line 2148: FROM MTL_SYSTEM_ITEMS_B

2144: -- Get the pack type attribute from MSI.
2145: -- IF the pack type is not null then return 'Y' otherwise return 'N'
2146: --SELECT Pack_Type INTO l_pack_type
2147: SELECT TRADE_ITEM_DESCRIPTOR INTO l_pack_type
2148: FROM MTL_SYSTEM_ITEMS_B
2149: WHERE inventory_item_id = p_inventory_item_id
2150: AND organization_id = p_organization_id;
2151:
2152: IF l_pack_type IS NOT NULL THEN