[Home] [Help]
148: |
149: | 22-Feb-2006 Kiran Konada
150: | bigfix 4615409
151: | get operation_lead_time percent from bom_operational_routings
152: | NOT from bom_inventory_components
153: |
154: |
155: | 23-Feb-2006 kiran Konada
156: | bugfix 5676839
280: l_stmt_num :=40;
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
309:
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
328: BEGIN
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
904: wil.line_code,
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,
947: wil.line_code,
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,