APPS.BOM_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 5: (p_cbill_sequence_id IN BOM_BILL_OF_MATERIALS.bill_sequence_id%TYPE)

1: PACKAGE BODY BOM_UTIL as
2: /* $Header: BOMUTILB.pls 120.1 2006/03/17 12:53:15 seradhak noship $ */
3: -- -----------------------------------------------------------------------
4: FUNCTION get_first_level_components
5: (p_cbill_sequence_id IN BOM_BILL_OF_MATERIALS.bill_sequence_id%TYPE)
6: RETURN NUMBER IS
7: l_first_level_count NUMBER := 0;
8: BEGIN
9:

Line 26: (p_bill_sequence_id IN BOM_BILL_OF_MATERIALS.bill_sequence_id%TYPE)

22: END get_first_level_components;
23:
24: -- -----------------------------------------------------------------------
25: FUNCTION get_change_order_count
26: (p_bill_sequence_id IN BOM_BILL_OF_MATERIALS.bill_sequence_id%TYPE)
27: RETURN NUMBER IS
28: l_change_order_count NUMBER := 0;
29: BEGIN
30:

Line 65: BOM_BILL_OF_MATERIALS bom

61: implementation_date is NOT NULL
62: AND bomc.bill_sequence_id IN -- For Bug Fix . 2832017
63: (SELECT common_bill_sequence_id
64: FROM
65: BOM_BILL_OF_MATERIALS bom
66: WHERE
67: bom.assembly_item_id = p_component_item_id
68: AND bom.organization_id = p_organization_id
69: -- Commented for Bug Fix 2832017

Line 132: FROM bom_bill_of_materials

128: l_structures_count NUMBER := 0;
129:
130: BEGIN
131: SELECT count(*) INTO l_structures_count
132: FROM bom_bill_of_materials
133: WHERE structure_type_id = p_structure_type_id;
134:
135: IF l_structures_count = 0 THEN
136: RETURN 'N';

Line 325: FROM bom_bill_of_materials bom,

321: SELECT 'Planning Bill'
322: INTO l_dummy
323: FROM sys.dual
324: WHERE EXISTS (SELECT 'Planning Item'
325: FROM bom_bill_of_materials bom,
326: mtl_system_items msi,
327: bom_inventory_components bic
328: WHERE msi.bom_item_type = 3 /* PLANNING */
329: AND msi.inventory_item_id = bom.assembly_item_id