[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
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
917: --bugfix 4615409
918: --bom_operational_routings bor_p,--parent
919: --bom_operation_sequences bos_p
914: --mtl_system_items msi,
915: bom_operational_routings bor,
916: wip_lines wil
917: --bugfix 4615409
918: --bom_operational_routings bor_p,--parent
919: --bom_operation_sequences bos_p
920: where bic.bill_sequence_id = bom.common_bill_sequence_id
921: and bom.assembly_item_id = pParentItemId
922: and bom.organization_id = pOrganization_id
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
964: --bugfix 4615409
965: --bom_operational_routings bor_p,--parent
966: --bom_operation_sequences bos_p
961: --mtl_System_items_b msi,
962: bom_operational_routings bor,
963: wip_lines wil
964: --bugfix 4615409
965: --bom_operational_routings bor_p,--parent
966: --bom_operation_sequences bos_p
967: where bic.bill_sequence_id = bom.common_bill_sequence_id
968: and bom.assembly_item_id = pParentItemId
969: and bom.organization_id = pOrganization_id
1046: -- 5198966
1047: BEGIN
1048: select nvl(bos_p.OPERATION_LEAD_TIME_PERCENT,0)
1049: INTO pitems_table(l_index).operation_lead_time_percent
1050: from bom_operational_routings bor_p,--parent
1051: bom_operation_sequences bos_p
1052: where bor_p.assembly_item_id = pParentItemId
1053: and bor_p.organization_id = pOrganization_id
1054: and bor_p.ALTERNATE_ROUTING_DESIGNATOR is null
1270: -- 5198966
1271: BEGIN
1272: select nvl(bos_p.OPERATION_LEAD_TIME_PERCENT,0)
1273: INTO pitems_table(l_index).operation_lead_time_percent
1274: from bom_operational_routings bor_p,--parent
1275: bom_operation_sequences bos_p
1276: where bor_p.assembly_item_id = pParentItemId
1277: and bor_p.organization_id = pOrganization_id
1278: and bor_p.ALTERNATE_ROUTING_DESIGNATOR is null
2162: l_routing_sequence_id
2163: FROM oe_order_lines_all oel,
2164: oe_order_headers_all oeh,
2165: mtl_system_items_kfv mtl,
2166: bom_operational_routings bor
2167: WHERE oel.line_id = p_Top_Assembly_LineId
2168: AND oeh.header_id = oel.header_id
2169: AND oel.inventory_item_id = mtl.inventory_item_id
2170: AND oel.ship_from_org_id = mtl.organization_id
3386: END IF;
3387:
3388: SELECT count(1)
3389: INTO l_routing_count_sa
3390: FROM bom_operational_routings bor,
3391: OE_ORDER_LINES_ALL oel
3392: WHERE oel.INVENTORY_ITEM_ID = l_mlsupply_items(l_index).item_id
3393: AND oel.INVENTORY_ITEM_ID = bor.assembly_item_id
3394: AND oel.ship_from_org_id = bor.organization_id
3932: BEGIN
3933: l_stmt_num := 70;
3934: select nvl(bos_p.OPERATION_LEAD_TIME_PERCENT,0)
3935: INTO pitems_table(l_index).operation_lead_time_percent
3936: from bom_operational_routings bor_p,--parent
3937: bom_operation_sequences bos_p
3938: where bor_p.assembly_item_id = pitems_table(l_parent_index).item_id
3939: and bor_p.organization_id = p_organization_id
3940: and bor_p.ALTERNATE_ROUTING_DESIGNATOR is null