APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on BOM_BILL_OF_MATERIALS

Line 183: FROM bom_bill_of_materials

179: CURSOR c_bom_count
180: IS
181:
182: SELECT bill_sequence_id,structure_type_id
183: FROM bom_bill_of_materials
184: WHERE
185: assembly_item_id = p_assembly_item_id
186: AND organization_id = p_organization_id
187: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

Line 341: FROM bom_bill_of_materials

337: CURSOR c_bom_count
338: IS
339:
340: SELECT bill_sequence_id,structure_type_id
341: FROM bom_bill_of_materials
342: WHERE
343: assembly_item_id = p_revised_item_id
344: AND organization_id = p_organization_id
345: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

Line 2100: bom_bill_of_materials bb,

2096: COUNT(1)
2097: INTO
2098: l_Count
2099: FROM
2100: bom_bill_of_materials bb,
2101: mtl_system_items_kfv it,
2102: mtl_parameters mp
2103: WHERE
2104: bb.assembly_item_id = it.inventory_item_id AND

Line 2145: FROM BOM_BILL_OF_MATERIALS bb,

2141: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_Already_Commoned');
2142: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| p_Item_Number || ' ORG CODE: '|| p_Organization_Code);
2143:
2144: SELECT bill_sequence_id, source_bill_sequence_id INTO l_bill_sequence_id, l_src_bill_sequence_id
2145: FROM BOM_BILL_OF_MATERIALS bb,
2146: mtl_system_items_kfv it,
2147: mtl_parameters mp
2148: WHERE bb.assembly_item_id = it.inventory_item_id
2149: AND it.organization_id = bb.organization_id

Line 2265: bom_bill_of_materials

2261: BEGIN
2262:
2263: SELECT bill_sequence_id INTO l_bill_sequence_id
2264: FROM
2265: bom_bill_of_materials
2266: WHERE
2267: assembly_item_id = p_assembly_item_id AND
2268: organization_id = p_organization_id AND
2269: NVL(alternate_bom_designator, 'NONE') =

Line 2325: l_alternate_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE;

2321: l_msg_Count NUMBER;
2322: l_reference_item_num mtl_system_items_kfv.concatenated_segments%TYPE;
2323: l_reference_org_code mtl_parameters.organization_code%TYPE;
2324: l_as_of_date DATE;
2325: l_alternate_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE;
2326: l_output_status inv_ebi_output_status;
2327:
2328: BEGIN
2329: SAVEPOINT process_replicate_bom_save_pnt;

Line 2414: bom_bill_of_materials

2410: bill_sequence_id
2411: INTO
2412: l_from_sequence_id
2413: FROM
2414: bom_bill_of_materials
2415: WHERE
2416: assembly_item_id = l_from_item_id AND
2417: organization_id = l_from_org_id AND
2418: ((l_revised_item.alternate_bom_code IS NULL AND alternate_bom_designator IS NULL) OR

Line 2706: FROM bom_bill_of_materials

2702:
2703: END IF;
2704:
2705: SELECT bill_sequence_id,structure_type_id INTO l_bill_sequence_id,l_structure_type_id
2706: FROM bom_bill_of_materials
2707: WHERE assembly_item_id = l_assembly_item_id
2708: AND organization_id = l_organization_id
2709: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2710:

Line 2745: FROM bom_bill_of_materials

2741:
2742: IF(p_structure_header IS NOT NULL AND p_structure_header.structure_header_uda IS NOT NULL AND p_structure_header.structure_header_uda.attribute_group_tbl.COUNT > 0) THEN
2743:
2744: SELECT bill_sequence_id,structure_type_id INTO l_bill_sequence_id,l_structure_type_id
2745: FROM bom_bill_of_materials
2746: WHERE assembly_item_id = l_assembly_item_id
2747: AND organization_id = l_organization_id
2748: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2749:

Line 2949: FROM bom_bill_of_materials

2945: )
2946: IS
2947: CURSOR C_Bill_seq (p_assembly_item_id NUMBER) IS
2948: SELECT bill_sequence_id
2949: FROM bom_bill_of_materials
2950: WHERE assembly_item_id = p_assembly_item_id
2951: AND organization_id = p_organization_id
2952: AND nvl(alternate_bom_designator,'x') = nvl(p_alternate_bom_code,'x');
2953:

Line 3975: FROM bom_bill_of_materials

3971: p_common_org_id IN NUMBER
3972: ) IS
3973:
3974: SELECT organization_id
3975: FROM bom_bill_of_materials
3976: WHERE
3977: common_bill_sequence_id = p_bill_sequence_id AND
3978: common_assembly_item_id = p_common_assy_item_id AND
3979: common_organization_id = p_common_org_id;