APPS.FLM_KANBAN dependencies on BOM_BILL_OF_MATERIALS

Line 95: FROM bom_bill_of_materials bbom,

91: bic.component_item_id,
92: decode(bic.wip_supply_type,null,msi.wip_supply_type,bic.wip_supply_type),
93: decode(bic.supply_subinventory,null,msi.wip_supply_subinventory,bic.supply_subinventory),
94: decode(bic.supply_subinventory,null,msi.wip_supply_locator_id,bic.supply_locator_id)
95: FROM bom_bill_of_materials bbom,
96: bom_inventory_components bic,
97: mtl_system_items msi
98: WHERE bbom.organization_id = i_org_id AND
99: bbom.alternate_bom_designator is null AND

Line 117: FROM bom_bill_of_materials bbom,

113: bic.component_item_id,
114: decode(bic.wip_supply_type,null,msi.wip_supply_type,bic.wip_supply_type),
115: decode(bic.supply_subinventory,null,msi.wip_supply_subinventory,bic.supply_subinventory),
116: decode(bic.supply_subinventory,null,msi.wip_supply_locator_id,bic.supply_locator_id)
117: FROM bom_bill_of_materials bbom,
118: bom_inventory_components bic,
119: mtl_system_items msi
120: WHERE bbom.organization_id = i_org_id AND
121: -- nvl(bbom.alternate_bom_designator, 'NONE') = nvl(l_alt, 'NONE') AND

Line 140: FROM bom_bill_of_materials bbom,

136: bic.component_item_id,
137: decode(bic.wip_supply_type,null,msi.wip_supply_type,bic.wip_supply_type),
138: decode(bic.supply_subinventory,null,msi.wip_supply_subinventory,bic.supply_subinventory),
139: decode(bic.supply_subinventory,null,msi.wip_supply_locator_id,bic.supply_locator_id)
140: FROM bom_bill_of_materials bbom,
141: bom_inventory_components bic,
142: mtl_system_items msi
143: WHERE bbom.organization_id = i_org_id AND
144: -- bbom.alternate_bom_designator IS NULL AND

Line 254: bom_bill_of_materials bom,

250: decode(bic.supply_subinventory, null, msi.wip_supply_locator_id, bic.supply_locator_id),
251: -1,
252: -1
253: from
254: bom_bill_of_materials bom,
255: bom_operational_routings bor,
256: bom_inventory_components bic,
257: mtl_system_items msi
258: where

Line 288: bom_bill_of_materials bom,

284: decode(bic.supply_subinventory, null, msi.wip_supply_locator_id, bic.supply_locator_id),
285: -1,
286: -1
287: from
288: bom_bill_of_materials bom,
289: bom_inventory_components bic,
290: mtl_system_items msi
291: where
292: bom.organization_id = p_org_id and

Line 1133: FROM bom_inventory_components bic, bom_bill_of_materials bbom

1129: ELSE
1130: -- find it in database
1131: SELECT sum(bic.component_quantity)
1132: INTO l_relevant(l_j).unit_qty
1133: FROM bom_inventory_components bic, bom_bill_of_materials bbom
1134: WHERE l_relevant(l_j).de_item_id = bbom.assembly_item_id
1135: and bbom.organization_id = l_org_id
1136: and bbom.alternate_bom_designator is null
1137: AND bbom.bill_sequence_id = bic.bill_sequence_id

Line 1164: from BOM_INVENTORY_COMPONENTS bic, BOM_BILL_OF_MATERIALS bbom

1160: l_relevant(l_total).unit_qty := 1;
1161: ELSE
1162: select sum(bic.COMPONENT_QUANTITY)
1163: into l_relevant(l_total).unit_qty
1164: from BOM_INVENTORY_COMPONENTS bic, BOM_BILL_OF_MATERIALS bbom
1165: where l_relevant(l_total).de_item_id = bbom.ASSEMBLY_ITEM_ID
1166: and bbom.organization_id = l_org_id
1167: and bbom.alternate_bom_designator is null
1168: AND bbom.BILL_SEQUENCE_ID = bic.BILL_SEQUENCE_ID