APPS.FLM_SUPPLY_DEMAND dependencies on BOM_BILL_OF_MATERIALS

Line 1338: BOM_BILL_OF_MATERIALS BOM ,

1334: F.primary_item_id assembly_item_id,
1335: F.bom_revision_date bom_revision_date,
1336: F.alternate_bom_designator alternate_bom_designator
1337: FROM WIP_FLOW_SCHEDULES F,
1338: BOM_BILL_OF_MATERIALS BOM ,
1339: BOM_EXPLOSIONS BE ,
1340: BOM_CALENDAR_DATES C,
1341: MTL_PARAMETERS P,
1342: MTL_SYSTEM_ITEMS I,

Line 1669: from bom_bill_of_materials

1665:
1666: if (p_alternate_bom_designator is not null) then
1667: select common_bill_sequence_id
1668: into l_top_bill_sequence_id
1669: from bom_bill_of_materials
1670: where assembly_item_id = p_assembly_item_id
1671: and organization_id = p_organization_id
1672: and alternate_bom_designator = p_alternate_bom_designator;
1673: else

Line 1676: from bom_bill_of_materials

1672: and alternate_bom_designator = p_alternate_bom_designator;
1673: else
1674: select common_bill_sequence_id
1675: into l_top_bill_sequence_id
1676: from bom_bill_of_materials
1677: where assembly_item_id = p_assembly_item_id
1678: and organization_id = p_organization_id
1679: and alternate_bom_designator is NULL;
1680: end if;