[Home] [Help]
281: select SUM( decode( nvl(bic.basis_type,1), 1 , bic.COMPONENT_QUANTITY/bic.component_yield_factor, 0 )) ,
282: SUM( decode( nvl(bic.basis_type,1), 2 , bic.COMPONENT_QUANTITY/bic.component_yield_factor, 0 )) , 'Y'
283: INTO x_comp_item_qty , x_comp_lot_qty, v_recurr_flag
284: FROM BOM_INVENTORY_COMPONENTS bic,
285: bom_bill_of_materials bom
286: WHERE bic.bill_sequence_id = bom.common_bill_sequence_id
287: and bom.assembly_item_id = p_parent_item_id
288: and bom.organization_id = p_organization_id
289: AND bic.COMPONENT_ITEM_ID = p_item_id
310: l_stmt_num :=70;
311: select min(OPERATION_SEQ_NUM)
312: into x_min_op_seq_num
313: FROM BOM_INVENTORY_COMPONENTS bic,
314: bom_bill_of_materials bom
315: WHERE bic.bill_sequence_id = bom.common_bill_sequence_id
316: and bom.assembly_item_id = p_parent_item_id
317: and bom.organization_id = p_organization_id
318: AND bic.COMPONENT_ITEM_ID = p_item_id
329: l_stmt_num :=80;
330: Select nvl(bos_p.OPERATION_LEAD_TIME_PERCENT,0)
331: INTO x_oper_lead_time_per
332: FROM BOM_INVENTORY_COMPONENTS bic,
333: bom_bill_of_materials bom,
334: --bugfix 4615409
335: bom_operational_routings bor_p,
336: bom_operation_sequences bos_p
337: WHERE bic.bill_sequence_id = bom.common_bill_sequence_id
908: nvl(bic.basis_type,1), /* LBM Project */
909: -- bic.wip_supply_type --4645636
910: nvl(bic.wip_supply_type, msi.wip_supply_type) -- Bug 9402188
911: from bom_inventory_components bic,
912: bom_bill_of_materials bom,
913: mtl_System_items_kfv msi,
914: --mtl_system_items msi,
915: bom_operational_routings bor,
916: wip_lines wil
955: nvl(bic.basis_type,1),/* LBM Project */
956: -- bic.wip_supply_type --4645636
957: nvl(bic.wip_supply_type, msi.wip_supply_type) --Bugfix 9402188
958: from bom_inventory_components bic,
959: bom_bill_of_materials bom,
960: mtl_System_items_kfv msi,
961: --mtl_System_items_b msi,
962: bom_operational_routings bor,
963: wip_lines wil