[Home] [Help]
39: | CTO_SUB_LEVEL_DISCRETE_REQ
40: |
41: | 24-Jan_2003 Kiran Konada
42: | bugfix 2755655 and 2756247
43: | added a outer joing bom_operational routings atbel
44: | if no routing is present, nvl(cfm_routing_flag to -99)
45: | modfied the if conditions to check for
46: | if(cfm_routing_flag = -99 or 2)
47: |
147: | Look at only primary BOM's
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
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
338: and bom.assembly_item_id = p_parent_item_id
339: and bom.organization_id = p_organization_id
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
914: --bugfix 4615409
915: --bom_operational_routings bor_p,--parent
916: --bom_operation_sequences bos_p
911: --mtl_system_items msi,
912: bom_operational_routings bor,
913: wip_lines wil
914: --bugfix 4615409
915: --bom_operational_routings bor_p,--parent
916: --bom_operation_sequences bos_p
917: where bic.bill_sequence_id = bom.common_bill_sequence_id
918: and bom.assembly_item_id = pParentItemId
919: and bom.organization_id = pOrganization_id
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
957: --bugfix 4615409
958: --bom_operational_routings bor_p,--parent
959: --bom_operation_sequences bos_p
954: --mtl_System_items_b msi,
955: bom_operational_routings bor,
956: wip_lines wil
957: --bugfix 4615409
958: --bom_operational_routings bor_p,--parent
959: --bom_operation_sequences bos_p
960: where bic.bill_sequence_id = bom.common_bill_sequence_id
961: and bom.assembly_item_id = pParentItemId
962: and bom.organization_id = pOrganization_id
1035: -- 5198966
1036: BEGIN
1037: select nvl(bos_p.OPERATION_LEAD_TIME_PERCENT,0)
1038: INTO pitems_table(l_index).operation_lead_time_percent
1039: from bom_operational_routings bor_p,--parent
1040: bom_operation_sequences bos_p
1041: where bor_p.assembly_item_id = pParentItemId
1042: and bor_p.organization_id = pOrganization_id
1043: and bor_p.ALTERNATE_ROUTING_DESIGNATOR is null
1236: -- 5198966
1237: BEGIN
1238: select nvl(bos_p.OPERATION_LEAD_TIME_PERCENT,0)
1239: INTO pitems_table(l_index).operation_lead_time_percent
1240: from bom_operational_routings bor_p,--parent
1241: bom_operation_sequences bos_p
1242: where bor_p.assembly_item_id = pParentItemId
1243: and bor_p.organization_id = pOrganization_id
1244: and bor_p.ALTERNATE_ROUTING_DESIGNATOR is null
2154: l_routing_sequence_id
2155: FROM oe_order_lines_all oel,
2156: oe_order_headers_all oeh,
2157: mtl_system_items_kfv mtl,
2158: bom_operational_routings bor
2159: WHERE oel.line_id = p_Top_Assembly_LineId
2160: AND oeh.header_id = oel.header_id
2161: AND oel.inventory_item_id = mtl.inventory_item_id
2162: AND oel.ship_from_org_id = mtl.organization_id
3900: BEGIN
3901: l_stmt_num := 70;
3902: select nvl(bos_p.OPERATION_LEAD_TIME_PERCENT,0)
3903: INTO pitems_table(l_index).operation_lead_time_percent
3904: from bom_operational_routings bor_p,--parent
3905: bom_operation_sequences bos_p
3906: where bor_p.assembly_item_id = pitems_table(l_parent_index).item_id
3907: and bor_p.organization_id = p_organization_id
3908: and bor_p.ALTERNATE_ROUTING_DESIGNATOR is null