[Home] [Help]
547: select oeh.order_number , msi.segment1, oel.line_number || '.' || oel.shipment_number
548: , msi.inventory_item_id , msi.organization_id
549: into v_order_number, v_top_model_name, v_top_model_line_num
550: , v_top_model_id, v_ship_from_org_id
551: from oe_order_headers_all oeh , oe_order_lines_all oel , mtl_system_items msi
552: where oeh.header_id = oel.header_id
553: and oel.line_id = lTopAtoLineId
554: and oel.inventory_item_id = msi.inventory_item_id
555: and oel.ship_from_org_id = msi.organization_id ;
701: oe_debug_pub.add( 'DROPPED component count > 0 ' , 1 ) ;
702:
703: select oeh.order_number , msi.segment1, oel.line_number || '.' || oel.shipment_number
704: into v_order_number, v_top_model_name, v_top_model_line_num
705: from oe_order_headers_all oeh , oe_order_lines_all oel , mtl_system_items msi
706: where oeh.header_id = oel.header_id
707: and oel.line_id = lTopAtoLineId
708: and oel.inventory_item_id = msi.inventory_item_id
709: and oel.ship_from_org_id = msi.organization_id ;
919:
920: select msi.segment1, oel.line_number || '.' || oel.shipment_number || '.' || nvl( oel.option_number , '' )
921: || '.' || nvl(component_number , '' )
922: into v_top_config_name, v_top_config_line_num
923: from oe_order_lines_all oel , mtl_system_items msi
924: where oel.ato_line_id = lTopAtoLineId
925: and item_type_code = 'CONFIG'
926: and oel.inventory_item_id = msi.inventory_item_id
927: and oel.ship_from_org_id = msi.organization_id ;
956:
957: select msi.segment1, oel.line_number || '.' || oel.shipment_number || '.' || nvl( oel.option_number , '' )
958: || '.' || nvl(component_number , '' )
959: into v_top_config_name, v_top_config_line_num
960: from oe_order_lines_all oel , mtl_system_items msi
961: where oel.ato_line_id = lTopAtoLineId
962: and item_type_code = 'CONFIG'
963: and oel.inventory_item_id = msi.inventory_item_id
964: and oel.ship_from_org_id = msi.organization_id ;
1329:
1330:
1331: select segment1
1332: into l_config_item_name
1333: from mtl_system_items
1334: where inventory_item_id = l_config_id
1335: and organization_id = l_mfg_org_id ;
1336: /* fixed bug 1853597 to retrieve only one row for each item */
1337:
1634: l_stmt_num := 170;
1635:
1636: select msi.primary_uom_code
1637: into l_primary_uom_code
1638: from mtl_system_items msi
1639: where msi.inventory_item_id = p_config_id
1640: and msi.organization_id = p_mfg_org_id;
1641:
1642: IF PG_DEBUG <> 0 THEN
1725: l_stmt_num := 190;
1726:
1727: select segment1
1728: into l_config_item_name
1729: from mtl_system_items
1730: where inventory_item_id = p_config_id
1731: and organization_id = p_mfg_org_id ;
1732:
1733:
1842: l_stmt_num := 215;
1843:
1844: select segment1
1845: into l_config_item_name
1846: from mtl_system_items
1847: where inventory_item_id = p_config_id
1848: and organization_id = p_mfg_org_id ;
1849:
1850:
1923:
1924:
1925: select segment1
1926: into l_config_item_name
1927: from mtl_system_items
1928: where inventory_item_id = p_config_id
1929: and organization_id = p_mfg_org_id ;
1930: /* fixed bug 1853597 to retrieve only one row for each item */
1931:
2991:
2992: l_msg_name varchar2(30);
2993: l_msg_txt varchar2(2000);
2994: l_msg_count number;
2995: l_inventory_item_id Mtl_system_items.inventory_item_id%type;
2996: l_ship_from_org_id Mtl_system_items.organization_id%type;
2997: l_item_type_code Oe_order_lines_all.item_type_code%type;
2998: x_return_status Varchar2(1);
2999: P_source_type Number;
2992: l_msg_name varchar2(30);
2993: l_msg_txt varchar2(2000);
2994: l_msg_count number;
2995: l_inventory_item_id Mtl_system_items.inventory_item_id%type;
2996: l_ship_from_org_id Mtl_system_items.organization_id%type;
2997: l_item_type_code Oe_order_lines_all.item_type_code%type;
2998: x_return_status Varchar2(1);
2999: P_source_type Number;
3000: p_sourcing_rule_exists Varchar2(1);
3730: oel.ato_line_id,--5108885
3731: oel.ato_line_id, oel.line_id,oel.top_model_line_id, oel.item_type_code --fix for bug#1874380
3732: into l_quantity, l_mfg_org_id, l_afas_line_id, l_ato_line_id, l_line_id,
3733: l_top_model_line_id,l_item_type_code
3734: from mtl_system_items msi,
3735: oe_order_lines_all oel
3736: where oel.line_id = to_number(p_itemkey)
3737: and (oel.open_flag is null
3738: or oel.open_flag = 'Y')
3873: --start bugfix 2318060
3874: BEGIN
3875: SELECT build_in_wip_flag
3876: INTO l_build_in_wip
3877: FROM mtl_system_items mtl,
3878: Oe_order_lines_all oel
3879: WHERE oel.line_id = to_number(p_itemkey)
3880: AND oel.inventory_item_id = mtl.inventory_item_id
3881: AND oel.ship_from_org_id = mtl.organization_id;
4194: +------------------------------------------------------------*/
4195: select 1
4196: into l_valid_model_line
4197: from oe_order_lines_all oel,
4198: mtl_system_items msi
4199: where oel.line_id = p_line_id
4200: and msi.organization_id = oel.ship_from_org_id
4201: and msi.inventory_item_id = oel.inventory_item_id
4202: and msi.bom_item_type = 1
4261: +------------------------------------------------------------*/
4262: select 1
4263: into l_valid_config_line
4264: from oe_order_lines_all oel,
4265: mtl_system_items msi
4266: where oel.line_id = p_config_line_id
4267: and msi.organization_id = oel.ship_from_org_id
4268: and oel.inventory_item_id = msi.inventory_item_id
4269: and msi.bom_item_type = 4
4391: --bugfix 1799874 end
4392:
4393: select sum(nvl(mrs.reservation_quantity,0))
4394: into x_reserved_quantity
4395: from mtl_system_items msi,
4396: oe_order_lines_all oel,
4397: mtl_reservations mrs
4398: where oel.line_id = p_config_line_id
4399: and oel.open_flag = 'Y'