APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on BOM_BILL_OF_MATERIALS

Line 180: FROM bom_bill_of_materials

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

Line 336: FROM bom_bill_of_materials

332: CURSOR c_bom_count
333: IS
334:
335: SELECT bill_sequence_id,structure_type_id
336: FROM bom_bill_of_materials
337: WHERE
338: assembly_item_id = p_revised_item_id
339: AND organization_id = p_organization_id
340: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

Line 1523: bom_bill_of_materials bb,

1519: COUNT(1)
1520: INTO
1521: l_Count
1522: FROM
1523: bom_bill_of_materials bb,
1524: mtl_system_items_kfv it,
1525: mtl_parameters mp
1526: WHERE
1527: bb.assembly_item_id = it.inventory_item_id AND

Line 1634: bom_bill_of_materials

1630: BEGIN
1631:
1632: SELECT bill_sequence_id INTO l_bill_sequence_id
1633: FROM
1634: bom_bill_of_materials
1635: WHERE
1636: assembly_item_id = p_assembly_item_id AND
1637: organization_id = p_organization_id AND
1638: NVL(alternate_bom_designator, 'NONE') =

Line 1692: l_alternate_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE;

1688: l_msg_Count NUMBER;
1689: l_reference_item_num mtl_system_items_kfv.concatenated_segments%TYPE;
1690: l_reference_org_code mtl_parameters.organization_code%TYPE;
1691: l_as_of_date DATE;
1692: l_alternate_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE;
1693: l_output_status inv_ebi_output_status;
1694:
1695: BEGIN
1696: SAVEPOINT process_replicate_bom_save_pnt;

Line 1776: bom_bill_of_materials

1772: bill_sequence_id
1773: INTO
1774: l_from_sequence_id
1775: FROM
1776: bom_bill_of_materials
1777: WHERE
1778: assembly_item_id = l_from_item_id AND
1779: organization_id = l_from_org_id AND
1780: ((l_revised_item.alternate_bom_code IS NULL AND alternate_bom_designator IS NULL) OR

Line 2063: FROM bom_bill_of_materials

2059:
2060: END IF;
2061:
2062: SELECT bill_sequence_id,structure_type_id INTO l_bill_sequence_id,l_structure_type_id
2063: FROM bom_bill_of_materials
2064: WHERE assembly_item_id = l_assembly_item_id
2065: AND organization_id = l_organization_id
2066: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2067:

Line 2102: FROM bom_bill_of_materials

2098:
2099: 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
2100:
2101: SELECT bill_sequence_id,structure_type_id INTO l_bill_sequence_id,l_structure_type_id
2102: FROM bom_bill_of_materials
2103: WHERE assembly_item_id = l_assembly_item_id
2104: AND organization_id = l_organization_id
2105: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2106:

Line 2267: FROM bom_bill_of_materials

2263: )
2264: IS
2265: CURSOR C_Bill_seq (p_assembly_item_id NUMBER) IS
2266: SELECT bill_sequence_id
2267: FROM bom_bill_of_materials
2268: WHERE assembly_item_id = p_assembly_item_id
2269: AND organization_id = p_organization_id
2270: AND nvl(alternate_bom_designator,'x') = nvl(p_alternate_bom_code,'x');
2271:

Line 3784: FROM bom_bill_of_materials

3780: p_common_org_id IN NUMBER
3781: ) IS
3782:
3783: SELECT organization_id
3784: FROM bom_bill_of_materials
3785: WHERE
3786: common_bill_sequence_id = p_bill_sequence_id AND
3787: common_assembly_item_id = p_common_assy_item_id AND
3788: common_organization_id = p_common_org_id;