[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:
1661: l_stmt_num := 170;
1662:
1663: select msi.primary_uom_code
1664: into l_primary_uom_code
1665: from mtl_system_items msi
1666: where msi.inventory_item_id = p_config_id
1667: and msi.organization_id = p_mfg_org_id;
1668:
1669: IF PG_DEBUG <> 0 THEN
1754: l_stmt_num := 190;
1755:
1756: select segment1
1757: into l_config_item_name
1758: from mtl_system_items
1759: where inventory_item_id = p_config_id
1760: and organization_id = p_mfg_org_id ;
1761:
1762:
1871: l_stmt_num := 215;
1872:
1873: select segment1
1874: into l_config_item_name
1875: from mtl_system_items
1876: where inventory_item_id = p_config_id
1877: and organization_id = p_mfg_org_id ;
1878:
1879:
1952:
1953:
1954: select segment1
1955: into l_config_item_name
1956: from mtl_system_items
1957: where inventory_item_id = p_config_id
1958: and organization_id = p_mfg_org_id ;
1959: /* fixed bug 1853597 to retrieve only one row for each item */
1960:
3024:
3025: l_msg_name varchar2(30);
3026: l_msg_txt varchar2(2000);
3027: l_msg_count number;
3028: l_inventory_item_id Mtl_system_items.inventory_item_id%type;
3029: l_ship_from_org_id Mtl_system_items.organization_id%type;
3030: l_item_type_code Oe_order_lines_all.item_type_code%type;
3031: x_return_status Varchar2(1);
3032: P_source_type Number;
3025: l_msg_name varchar2(30);
3026: l_msg_txt varchar2(2000);
3027: l_msg_count number;
3028: l_inventory_item_id Mtl_system_items.inventory_item_id%type;
3029: l_ship_from_org_id Mtl_system_items.organization_id%type;
3030: l_item_type_code Oe_order_lines_all.item_type_code%type;
3031: x_return_status Varchar2(1);
3032: P_source_type Number;
3033: p_sourcing_rule_exists Varchar2(1);
3763: oel.ato_line_id,--5108885
3764: oel.ato_line_id, oel.line_id,oel.top_model_line_id, oel.item_type_code --fix for bug#1874380
3765: into l_quantity, l_mfg_org_id, l_afas_line_id, l_ato_line_id, l_line_id,
3766: l_top_model_line_id,l_item_type_code
3767: from mtl_system_items msi,
3768: oe_order_lines_all oel
3769: where oel.line_id = to_number(p_itemkey)
3770: and (oel.open_flag is null
3771: or oel.open_flag = 'Y')
3906: --start bugfix 2318060
3907: BEGIN
3908: SELECT build_in_wip_flag
3909: INTO l_build_in_wip
3910: FROM mtl_system_items mtl,
3911: Oe_order_lines_all oel
3912: WHERE oel.line_id = to_number(p_itemkey)
3913: AND oel.inventory_item_id = mtl.inventory_item_id
3914: AND oel.ship_from_org_id = mtl.organization_id;
4280: +------------------------------------------------------------*/
4281: select 1
4282: into l_valid_model_line
4283: from oe_order_lines_all oel,
4284: mtl_system_items msi
4285: where oel.line_id = p_line_id
4286: and msi.organization_id = oel.ship_from_org_id
4287: and msi.inventory_item_id = oel.inventory_item_id
4288: and msi.bom_item_type = 1
4353: +------------------------------------------------------------*/
4354: select 1
4355: into l_valid_config_line
4356: from oe_order_lines_all oel,
4357: mtl_system_items msi
4358: where oel.line_id = p_config_line_id
4359: and msi.organization_id = oel.ship_from_org_id
4360: and oel.inventory_item_id = msi.inventory_item_id
4361: and msi.bom_item_type = 4
4490: --bugfix 1799874 end
4491:
4492: select sum(nvl(mrs.reservation_quantity,0))
4493: into x_reserved_quantity
4494: from mtl_system_items msi,
4495: oe_order_lines_all oel,
4496: mtl_reservations mrs
4497: where oel.line_id = p_config_line_id
4498: and oel.open_flag = 'Y'