[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
sqltxt := ' SELECT count(*) ' ||
' FROM' ||
' mtl_serial_numbers msn ,' ||
' mtl_system_items msi,' ||
' wsh_delivery_details wdd' ||
' where msn.inventory_item_id=msi.inventory_item_id' ||
' and msi.organization_id=msn.current_organization_id' ||
' and msn.current_status =3' ||
' and msi.reservable_type=1' ||
' and msi.serial_number_control_code not in (1,6)' ||
' and (msn.group_mark_id is NULL or msn.group_mark_id = -1 )' ||
' and msn.current_organization_id = wdd.organization_id ' ||
' and msn.inventory_item_id = wdd.inventory_item_id' ||
' and msn.serial_number = wdd.serial_number' ||
' and wdd.transaction_temp_id is null' ||
' and wdd.released_status in (''C'',''Y'') ' ||
' and wdd.inv_interfaced_flag in (''N'',''P'')' ;
sqltxt := ' SELECT count(*) ' ||
' FROM' ||
' mtl_serial_numbers msn,' ||
' mtl_system_items msi,' ||
' wsh_delivery_details wdd,' ||
' mtl_serial_numbers_temp msnt' ||
' where msn.inventory_item_id=msi.inventory_item_id' ||
' and msi.organization_id=msn.current_organization_id' ||
' and msn.current_status =3' ||
' and msi.reservable_type=1' ||
' and msi.serial_number_control_code not in (1,6)' ||
' and ( group_mark_id is NULL or group_mark_id =-1 )' ||
' and msn.current_organization_id = wdd.organization_id ' ||
' and msn.inventory_item_id = wdd.inventory_item_id' ||
' and wdd.released_status in (''C'',''Y'') ' ||
' and wdd.inv_interfaced_flag in (''N'',''P'')' ||
' and wdd.transaction_temp_id = msnt.transaction_temp_id' ||
' and msn.serial_number BETWEEN msnt.fm_serial_number and msnt.to_serial_number ';
sqltxt := ' SELECT count(*) ' ||
' FROM' ||
' mtl_serial_numbers msn ,' ||
' mtl_system_items msi,' ||
' wsh_delivery_details wdd,' ||
' wsh_serial_numbers wsn' ||
' where msn.inventory_item_id=msi.inventory_item_id' ||
' and msi.organization_id=msn.current_organization_id' ||
' and msn.current_status =3' ||
' and msi.reservable_type=1' ||
' and msi.serial_number_control_code not in (1,6)' ||
' and ( group_mark_id is NULL or group_mark_id =-1 )' ||
' and msn.current_organization_id = wdd.organization_id ' ||
' and msn.inventory_item_id = wdd.inventory_item_id' ||
' and wdd.transaction_temp_id is not null' ||
' and wdd.released_status in (''C'',''Y'') ' ||
' and wdd.inv_interfaced_flag in (''N'',''P'')' ||
' and wdd.delivery_detail_id = wsn.delivery_detail_id' ||
' and msn.serial_number BETWEEN wsn.fm_serial_number and wsn.to_serial_number ';
sqltxt := 'select mp.organization_code || '' ('' || msn.current_organization_id ||'')'' "Organization|Code (Id)" ,' ||
' msi.item_number || '' ('' || msn.inventory_item_id || '')'' "Item (Id)" ,' ||
' msn.serial_number "Serial Number",' ||
' msn.group_mark_id "Group Mark Id",' ||
' wdd.source_header_number "Order number",' ||
' wdd.source_line_id "Order line id",' ||
' wdd.delivery_Detail_id "Delivery detail Id"' ||
' from ' ||
' mtl_serial_numbers msn ,mtl_item_flexfields msi,' ||
' mtl_parameters mp, wsh_delivery_Details wdd' ||
' where mp.organization_id = msn.current_organization_id ' ||
' and msn.inventory_item_id=msi.inventory_item_id' ||
' and msi.organization_id=msn.current_organization_id' ||
' and msn.current_status =3 ' ||
' and msi.reservable_type=1' ||
' and msi.serial_number_control_code not in (1,6)' ||
' and (group_mark_id is NULL or group_mark_id =-1 ) ' ||
' and msn.serial_number = wdd.serial_number ' ||
' and wdd.released_status in (''C'',''Y'') ' ||
' and wdd.inv_interfaced_flag in (''N'',''P'')' ||
' and wdd.organization_id=msn.current_organization_id' ||
' and wdd.inventory_item_id=msn.inventory_item_id' ||
' and wdd.serial_number=msn.serial_number' ||
' and wdd.transaction_temp_id is null ';
sqltxt := ' select mp.organization_code || ''('' || msn.current_organization_id || '')'' "Organization|Code (Id)" ,' ||
' msi.item_number || ''('' || msn.inventory_item_id || '')'' "Item (Id)" ,' ||
' msn.serial_number "Serial Number",' ||
' msn.group_mark_id "Group Mark Id",' ||
' wdd.source_header_number "Order number",' ||
' wdd.source_line_id "Order line id",' ||
' wdd.delivery_Detail_id "Delivery detail Id"' ||
' from mtl_serial_numbers msn ,' ||
' mtl_item_flexfields msi,' ||
' mtl_parameters mp, ' ||
' wsh_delivery_details wdd,' ||
' mtl_serial_numbers_temp msnt' ||
' where mp.organization_id = msn.current_organization_id' ||
' and msn.inventory_item_id=msi.inventory_item_id' ||
' and msi.organization_id=msn.current_organization_id' ||
' and msn.current_status =3' ||
' and msi.reservable_type=1' ||
' and msi.serial_number_control_code not in (1,6)' ||
' and (group_mark_id is NULL or group_mark_id =-1 )' ||
' and msn.current_organization_id = wdd.organization_id ' ||
' and msn.inventory_item_id = wdd.inventory_item_id' ||
' and wdd.released_status in (''C'',''Y'') ' ||
' and wdd.inv_interfaced_flag in (''N'',''P'')' ||
' and wdd.transaction_temp_id = msnt.transaction_temp_id' ||
' and msn.serial_number BETWEEN msnt.fm_serial_number and msnt.to_serial_number ';
sqltxt := 'select mp.organization_code || '' ('' || msn.current_organization_id ||'')'' "Organization|Code (Id)" ,' ||
' msi.item_number || '' ('' || msn.inventory_item_id || '')'' "Item (Id)" ,' ||
' msn.serial_number "Serial Number",' ||
' msn.group_mark_id "Group Mark Id",' ||
' wdd.source_header_number "Order number",' ||
' wdd.source_line_id "Order line id",' ||
' wdd.delivery_Detail_id "Delivery detail Id"' ||
' from' ||
' mtl_serial_numbers msn ,mtl_item_flexfields msi,' ||
' mtl_parameters mp, wsh_serial_numbers wsn ,wsh_delivery_details wdd' ||
' where mp.organization_id = msn.current_organization_id ' ||
' and msn.inventory_item_id=msi.inventory_item_id' ||
' and msi.organization_id=msn.current_organization_id' ||
' and msn.current_status =3 ' ||
' and msi.reservable_type=1' ||
' and msi.serial_number_control_code not in (1,6)' ||
' and ( group_mark_id is NULL or group_mark_id =-1) ' ||
' and wdd.transaction_temp_id is not NULL' ||
' and wsn.delivery_detail_id=wdd.delivery_detail_id' ||
' and wdd.organization_id=msn.current_organization_id' ||
' and wdd.inventory_item_id=msn.inventory_item_id' ||
' and wsn.fm_serial_number=msn.serial_number' ||
' and wsn.fm_serial_number=wsn.to_serial_number' ||
' and wdd.released_status in (''C'',''Y'') ' ||
' and wdd.inv_interfaced_flag in (''N'',''P'') ' ;