[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
905: end_assembly_pegging_flag, --Bugfix# 3418102
906: nvl(bic.basis_type,1), /* LBM Project */
907: bic.wip_supply_type --4645636
908: from bom_inventory_components bic,
909: bom_bill_of_materials bom,
910: mtl_System_items_kfv msi,
911: --mtl_system_items msi,
912: bom_operational_routings bor,
913: wip_lines wil
948: end_assembly_pegging_flag, --Bugfix# 3418102
949: nvl(bic.basis_type,1),/* LBM Project */
950: bic.wip_supply_type --4645636
951: from bom_inventory_components bic,
952: bom_bill_of_materials bom,
953: mtl_System_items_kfv msi,
954: --mtl_System_items_b msi,
955: bom_operational_routings bor,
956: wip_lines wil